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 |
|
purushotham216
Starting Member
14 Posts |
 Posted - 2009-05-27 : 08:03:17
|
| HI ,Thanks in advance..I want to give single user permission to access a database (sql server 2005).how to do that? i tried like this ,i created a database(as a SINGLE USER),but with that login i am not able access tables. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-05-27 : 10:06:23
|
| SINGLE USER mode just means that only 1 user at a time can have access to the database. You still need to grant permissions for any given user to the database. One reason to use Single User mode is to perform Admin tasks (like RESTORE) without risk of colliding with other concurrent users. You can allow access to a database through Object Explorere. Navigate to server, explore the Logins section. Individual object permissions within the database can be managed through Object Explorer | <Database> | Security.Be One with the OptimizerTG |
 |
|
|
|
|
|
create access permission to single user