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 |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-05-01 : 07:26:22
|
| hi all how cani view all permissions given to particular useris theie any queryordo we have any sql command 4 thisThanks in advanceMalathi Rao |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-05-01 : 08:25:28
|
| I have often wondered this myself if there was a way of finding out which users have permission on for example a table, I will be also very intrested if anyone has an answer to this one.If only there was "exec sp_helppermmissions 'Customers'" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-01 : 10:02:19
|
| Try sp_helprotect. |
|
|
|
|
|
|
permissions