http://snipplr.com/language/sql/tags/security Recent snippets posted on Snipplr.com en-us Sat, 25 May 2013 09:54:56 GMT http://snipplr.com/view/70318/auditing-sql-server-user-and-role-permissions-for-databases/ 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)

]]> Fri, 08 Mar 2013 01:47:47 GMT http://snipplr.com/view/70318/auditing-sql-server-user-and-role-permissions-for-databases/ http://snipplr.com/view/60539/maps-an-existing-database-user-to-a-sql-server-login/

]]> Fri, 04 Nov 2011 07:47:25 GMT http://snipplr.com/view/60539/maps-an-existing-database-user-to-a-sql-server-login/ http://snipplr.com/view/16722/change-owner-on-sql-server-db/

]]> Tue, 07 Jul 2009 06:09:31 GMT http://snipplr.com/view/16722/change-owner-on-sql-server-db/ http://snipplr.com/view/2603/script-to-create-a-script-granting-execute-to-all-stored-procs-in-a-db/

]]> Sun, 06 May 2007 14:47:51 GMT http://snipplr.com/view/2603/script-to-create-a-script-granting-execute-to-all-stored-procs-in-a-db/