Profile
Achievement
![first submission:submitting first snipplet first submission:submitting first snipplet](/img/badge/badge_2.png?v3)
edwinet's Recent SnippetsTagged security
- All /
« Prev 1 Next »
The sysprotects system table reports all of the permissions granted or denied in a given database. We'll need to join it with sysusers and sysobjects to get all the information we need. Here's an example query that only pulls information on objects (...
0
898
posted 11 years ago by edwinet