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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-12-04 : 08:23:47
|
| Hi all, When we want to check the access privilege of a particular table, we can use "exec sp_table_privileges <table_name>" in T-SQL. Is there a similar built-in stored procedure to check the execute privilege of a stored procedure, from T-SQL? Thank you,delpiero |
|
|
cfederl
Starting Member
26 Posts |
Posted - 2005-12-04 : 11:15:55
|
| I have replied to this same post at SQLServerCentral.comCarl Federl |
 |
|
|
delpiero
Yak Posting Veteran
98 Posts |
Posted - 2005-12-04 : 11:35:17
|
| Thanks a lot Carl. Carl mentioned using sp_MSobjectprivs which is exactly what I need. delpiero |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 00:23:06
|
and note that sp_MSobjectprivs is undocumented  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Checking stored procedure privilege by T-SQL