Everyone's Recent SQL Snippets Tagged security

• All /
• JavaScript /
• HTML /
• PHP /
• CSS /
• Ruby /
• Objective C

1. 

   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 (...
   SQL
   • query
   • security
   • sql
   12 views posted 6 years ago by edwinet
2. 

   Maps an existing database user to a SQL Server login.

   SQL
   • security
   12 views posted 8 years ago by edwinet
3. 

   Change owner on sql server db.

   SQL
   • security
   • server
   • sql
   5 views posted 10 years ago by d020
4. 

   Script to Create a Script Granting EXECUTE to all Stored Procs in a DB

   SQL
   • script
   • security
   • sql
   12 views posted 12 years ago by rengber