Create security for an application.

  • hello,

    My name is yann, I'm french. I want to learn how securize an application asp.net 2.0.

    SECURITY OF THE APPLICATION :

    - The application have a sa with a password to access the db sql serveur 2005.

    - The application have user with password for accessing to the application in the database in table USER.

    How securize the DB ? if i could see a course, that's amazing but it cost too much so i prefere learn with forums and tutorials.

    thanks to listen me.

    French Geek.
    http://blog.developpez.com/ylarvor
    I work my english 🙂

  • Stop the application using the sa login for a start. And when you do, change the password.

    Try and architect your application to use either Windows Authentication or an application role to connect to the database, with only those rights it requires (i.e. NOT sysadmin, NOT db_owner).

    Check out these topics in SQL Server 2005 Books Online (comes with SQL Server):

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/scsql9/html/4d93489e-e9bb-45b3-8354-21f58209965d.htm

    Bonne chance!



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare


  • Thank for your answer...

    I cant read the link ! not in help of sql serveur 2005 and not in internet explorer ? how can i read the link.

    A bientot.

    Yann

    French Geek.
    http://blog.developpez.com/ylarvor
    I work my english 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply