Set password for a single database

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 2005 Forums

Transact-SQL (2005)

Set password for a single database

Author

Topic

krushnapanda
Starting Member

18 Posts

Posted - 2007-12-08 : 01:45:44

hello dear
I am using SQL Server 2005
In Microsoft SQL Server Management Studio
Object Explorer-- under Databases folder
i have 5 database
say DB1 , DB2 , DB3, DB4 , DB5
i want to set security or set password for the database DB3 only
means
how to set security or how to set password for a particular DataBase
from th database list

thanks

Thanks

georgev
Posting Yak Master

122 Posts

Posted - 2007-12-08 : 14:55:14

This isn't relaly transactional SQL now, is it?

Anyhow - create separate users/logins and only give them access to the DB's you want.

George
<3Engaged!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-08 : 17:38:00

You can't set password for db, should control db access permission for sql logins as said above.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources