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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2008-07-11 : 16:22:56
|
| Hi,We have given a following permission to user:GRANT EXECUTE ON master..xp_sendmail TO testGoIn which system tables can we check all the permissions granted to this “test” user?Thanks--rubs |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2008-07-11 : 16:38:38
|
| I am not able to see the required information using sp_helpuser (I am interested in seeing permission mentioned in initial post "Execute on xp_sendmail") Also I am looking to get information quering directly metadata/sys tables and not using system functions.Is this possible?Thanks--rubs |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-11 : 16:53:14
|
| My post says sys.database_permissions. And it is always best to use system functions or INFORMATION_SCHEMA views if possible rather than system tables.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-11 : 16:58:14
|
| Take a look at this from bol. Also look xp_cmdshell.http://msdn.microsoft.com/en-us/library/ms176097.aspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-11 : 23:31:13
|
| >> I am not able to see the required information using sp_helpuser If you want to use system sp, try sp_helprotect. |
|
|
|
|
|
|
Which metadata tables to check for permissions?