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 |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2006-11-21 : 14:04:35
|
| How to check the what permissions a users has and also how to grant the create database permissions for a existing user.Thanks for the help in advance.. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-21 : 14:22:59
|
| Books Online:sp_helprotectGRANTGranting Permissionspermissions |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-11-22 : 00:32:47
|
Hi,from the root console(in the enterprise manager)go to security-->click logins->>all the logins wld be displayed..highlight the user for which u want to check permissionsright click on the user and click properties ->>click server roles to see what roles the user has..click database access tab to see other permissions...but to veiw all these you shld have enough rights... its me monty |
|
|
|
|
|
|
sqlserver 2000 database permissions