edwinet


Member since 08/14/2010

2 snippets

355 profile views

0 Comment(s) Posted

View their favorites

Profile

Achievement

first submission:submitting first snipplet

edwinet's Recent SnippetsTagged security



« 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 180 posted 7 years ago by edwinet
« Prev 1 Next »