Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged security

« Prev 1 Next »
  1. FAV

    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 12 views posted 6 years ago by edwinet
  2. FAV

    Maps an existing database user to a SQL Server login.

    SQL 12 views posted 8 years ago by edwinet
  3. FAV

    Change owner on sql server db.

    SQL 5 views posted 10 years ago by d020
  4. FAV

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

    SQL 12 views posted 12 years ago by rengber
« Prev 1 Next »