Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 MSSQL Database Security issue

Author  Topic 

tshorolpa
Starting Member

1 Post

Posted - 2010-08-31 : 07:34:46
Hi Everyone,

i have a MSSQL database server 2008, which is used and can be connected to my software developers for the developnment process. They all are using 'sa' account.
but i want to make one database where i can put my confidential info, and i want that database to be inaccessible to my developers.

how can i achieve that? Please describe me in steps so that i can follow easily.

Thank you Very much

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-31 : 11:56:23
Achieve it by not allowing your developers to use sa account. Sa is very bad, only DBAs should have the password for it. Restrict development access to db_owner in their user databases.

Or put your confidential info into a separate SQL instance that they don't have sa.

Or encrypt your data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -