Welcome To Snipplr


Everyone's Recent SQL Snippets Tagged 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 1266 posted 12 years ago by edwinet
0 1003 posted 15 years ago by d020
« Prev 1 Next »