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 |
|
LA768
Starting Member
9 Posts |
 Posted - 2007-09-13 : 11:40:21
|
| How do you take an audit of all stored proceduresin a database and check who has access to them?I have a database with a ton of SP's and I wantto know who has "EXEC" rights to each of themand who.Thanks in advance.LA768Larry :-) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-13 : 23:33:36
|
| Unless you trace them in profiler, or modify sp to add usage count to table. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-14 : 04:43:11
|
| sp_helprotect possibly? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-15 : 00:26:12
|
| That lists permission, have exec permission on the sp doesn't mean really run it. |
|
|
|
LA768
Starting Member
9 Posts |
Posted - 2007-09-15 : 15:40:10
|
| Thanks guys. I can't really monitor them on the profileror modify the sp's for a counter. sp_helprotect does nothelp. Any other suggestions?Larry :-) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-15 : 16:34:03
|
| Third party auditing tools. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-15 : 17:30:11
|
| you can try to use SQL Server's C2 auditing._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Stored Procedure Access Audit