Auditing SQL Server User and Role Permissions for Databases


/ Published in: SQL
Save to your folder(s)

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 (no CREATE TABLE permissions or anything else at the database level)

URL: http://www.mssqltips.com/sqlservertip/2132/auditing-sql-server-user-and-role-permissions-for-databases/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.