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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-18 : 23:49:15
|
| kavita writes "I am using sql server 2000. I want a particular database should not be accessible to users or only authenticated user should be able to access database.How to do that.Thanks." |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-02-19 : 07:08:01
|
| That's what permissions are for. Only give rights to the database for those user accounts you want to access it. Make sure the user accounts don't have sysadmin roles for the server. |
 |
|
|
|
|
|
Database Security Issue