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

Scripts with tag users Rss

Search for any content tagged users

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 9 of 9   
 

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 | 774 reads

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.  Read more...
By Edward Pochinski 2016/02/23 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 829 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,552 reads

Script All Logins / Users / and Roles

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.   Read more...
By Greg Ryan 2015/09/07 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 4,704 reads

Fix users for SQL 7 thru 2008

This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.  Read more...
By Mike Tutor 2010/02/19 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 2,154 reads

Database Users And Associated Database Roles

This script basically retreives all database users thier database roles for a database.   Read more...
By Larry Sumuri 2010/02/10 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 3,358 reads

List orphaned users from all databases

The script returns all orphaned database users across a SQL Server.  Read more...
By James Howard 2013/07/15 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,091 reads

Terminate All User Processes Without Stored Procedure in SQL Server

This script kill all connections on the specified database without stored procedure.  Read more...
By andre.brunaldi 2008/09/10 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 254 reads

show users in NT Groups

List users in NT Groups  Read more...
By Mani Singh 2008/07/29 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 1,218 reads
   Items 1 to 9 of 9