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 2000 Forums
 SQL Server Development (2000)
 How to protect the newly created database

Author  Topic 

anupalavila
Yak Posting Veteran

56 Posts

Posted - 2008-10-15 : 02:53:37
Hai,

In my sqlserver2000 I have SQL server authentication with username sa and password admin,this username and password is known to all users who are accessing the my sqlserver200, working on different databases in it. I have created a new database and I want to protect the newly created database with a username and password.


Thanks and Regards
Anu Palavila

Thanks and Regards
Anu Palavila

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-10-15 : 03:40:48
if the other users also log in as 'sa', you cannot prevent them accessing the DB

Em
Go to Top of Page
   

- Advertisement -