Create security for an application.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Create security for an application.

Create security for an application.

Rate Topic

Display Mode

Topic Options

Author

Message

yann.larvor

Posted Tuesday, January 15, 2008 6:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 21, 2010 12:21 PM
Points: 37, Visits: 130

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 :)

Post #442952

The CosmicTrickster

Posted Wednesday, January 16, 2008 6:03 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:34 PM
Points: 2,605, Visits: 760

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

Post #444080

yann.larvor

Posted Thursday, January 17, 2008 12:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 21, 2010 12:21 PM
Points: 37, Visits: 130

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 :)

Post #444160

« Prev Topic | Next Topic »

Permissions