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 |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2008-10-23 : 02:25:58
|
| Hi,I have SQL Sever 2005 installed with many databases. I need to grant access to only one user to specific databases. How can this be. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 02:32:04
|
| add the users login to database from sql management studio object explorer.B/w are you using sql authentication mode or mixed mode? |
 |
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-10-23 : 02:36:36
|
| Hi,Can you please give me the different steps i need to perform?I never did this beforeI'm using the windows authentication mode, not the mixed mode.Thanks for your quick reply... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Databases Privileges