Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag User Rss

Search for any content tagged user

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 8 of 8   
 

Script DB Level Permissions v4

Script database and object level permissions for all database users  Read more...
By S. Kusen 2016/03/22 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 964 reads

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2015/10/30 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 3,278 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,835 reads

Delete All Database User Accounts for a Given Server Login

Easily and quickly delete all database accounts even if they don't have the same name as server login.  Read more...
By Hakim Ali 2015/05/05 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,798 reads

Audit All Permissions

This script will return all permissions on the server.  Read more...
By Jim Sebastiano 2011/11/16 | Source: SQLServerCentral.com | Category: permission
Rating: |  Discuss |   Briefcase | 3,600 reads

Relationship between users and Databases

Show the users inside the databases  Read more...
By Ricardo Leka 2011/05/30 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,318 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 13,803 reads

get users across all databases on the SQL Server instance

Quick way to get all users on all Databases  Read more...
By Mani Singh 2008/07/24 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 1,636 reads
   Items 1 to 8 of 8