SQL Clone
SQLServerCentral is supported by Redgate
 
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 20 of 26    Older >>
 

Login restriction from selected applications and users

It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details  Read more...
Rating: |  Discuss |   Briefcase | 222 reads

PowerShell for Server/DB/Object level Permissions/Logins/Roles/Users

PowerShell to generate Server Level Permissions/Logins/Roles, Object/Database Level Permissions.  Read more...
Rating: |  Discuss |   Briefcase | 525 reads

Script DB Level Permissions v4.3

Script database and object level permissions for all database users  Read more...
By S. Kusen 2017/07/25 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 1,539 reads

Fix Orphan Users for Instance Migration

Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.  Read more...
By Ajay Dwivedi 2016/01/04 | Source: SQLServerCentral.com | Category: migration
Rating: |  Discuss |   Briefcase | 1,315 reads

Generate Login Script(2008R2 And Older)

Generate Script from Logins of Sql Server to recreate in another instance  Read more...
By Bahram Shayan 2015/08/25 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,690 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,606 reads

Capture User Auths For Database

This script captures user authorizations by database (default) or by SQL instance   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 1,547 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 2016/11/02 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 5,850 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 2015/03/02 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,852 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,355 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,892 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,937 reads

Top 14 KPI

Get the 14 most used Key Performance Indicators  Read more...
By Monte Kottman 2015/09/22 | Source: SQLServerCentral.com | Category: kpi
Rating: |  Discuss |   Briefcase | 4,373 reads

Login Password Policy

This script lists all of the SQL logins with their password policy  Read more...
Rating: |  Discuss |   Briefcase | 1,797 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,236 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,604 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,702 reads

Verify SQL Server Login and Login Settings

Verifies that a specified login name exists and has correct settings.  Read more...
By Seth Delconte 2011/07/27 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,658 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,699 reads

Script DB Level Permissions v3

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 | 8,474 reads
   Items 1 to 20 of 26    Older >>