Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Logins Rss

Search for any content tagged logins

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

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 2013/11/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,568 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 2013/11/12 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,965 reads

Capture_Login_Auths

This procedure takes a login name and will generate the access and authorities for the login across the SQL instance.  Read more...
By Donald Patterson 2014/06/11 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,909 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 2013/11/04 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,902 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,334 reads

Top 14 KPI

Get the 14 most used Key Performance Indicators  Read more...
By Monte Kottman 2012/11/09 | Source: SQLServerCentral.com | Category: kpi
Rating: |  Discuss |   Briefcase | 2,732 reads

Login Password Policy

This script lists all of the SQL logins with their password policy  Read more...
Rating: |  Discuss |   Briefcase | 1,623 reads

Remove Logins Script

Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.  Read more...
By Steve Griffith 2012/04/05 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,188 reads

Get SQL Server Login Information

The following script is useful to get SQL Server 2005 Login Information e.g., SQL Instance Logins, SQL Logins Server Roles, SQL Logins Database Mapping  Read more...
By Bilal Mahmood 2012/02/27 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,429 reads

Script Logins

Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying.  Read more...
By Gordon Klundt 2011/04/04 | Source: SQLServerCentral.com | Category: sp_help_revlogin
Rating: |  Discuss |   Briefcase | 2,633 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,872 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,109 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 | 12,760 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,264 reads

Audit SQL Logins - Updated

SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.   Read more...
By Derrick H. 2011/05/23 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 12,840 reads
   Items 1 to 15 of 15