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 |
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
 Posted - 2010-10-11 : 03:02:27
|
| Hi all... I want to set a database password in my server to access my particular database only(restrict the users to handle datas)...Except the login password I want to set password for my DB only... It's possible in sql server 2005Tnx in advance.. |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2010-10-11 : 07:15:40
|
| You will need to create a SQL Server login at Server level, then create the user as a dbrole DB_Reader on the database you want them to be able to see data inAlso set the Server level logins default database to the one you want. |
 |
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-11 : 08:03:49
|
| Tnx for the reply... |
|
|
|
|
|
|
Creating permission for database access..