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

Content with tag Logins Rss

   Items 1 to 20 of 27    Older >>
 

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,887 reads

Database User Superfluousness In SQL Server

In this article, Thomas Knight analyzes and critiques the design of, and experience with, the "dual-level" user security in SQL Server. He then demonstrates a better theoretical alternative.  Read more...
By Thomas Knight 2014/02/04 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 3,886 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,680 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 2013/11/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,543 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,894 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,887 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,285 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,848 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,658 reads

Script to clean up “Windows” logins no longer in AD

I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get rid of...  Read more...
By Kenneth Fisher 2013/03/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,397 reads

Logins vs Users

Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....  Read more...
By Kenneth Fisher 2012/12/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,293 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,704 reads

Login Password Policy

This script lists all of the SQL logins with their password policy  Read more...
Rating: |  Discuss |   Briefcase | 1,615 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,183 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,413 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,258 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,822 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,628 reads

Re-generating SQL Server Logins

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.   Read more...
By Additional Articles 2011/02/08 | Source: Database Journal | Category: security
Rating:  Rate this |   Briefcase | 4,964 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,680 reads
   Items 1 to 20 of 27    Older >>
 
Tags
security (12)    
users (5)    
auditing (4)    
permissions (4)    
role (3)    
roles (3)    
user (3)    
administration (2)    
blogs (2)    
comparison (2)    
members (2)    
ownership (2)    
principals (2)    
script (2)    
secure (2)    
sql server 7 (2)    
batch requests per sec (1)    
buffer cache hit ratio (1)    
connections (1)    
cpu (1)    
database authorities (1)    
database restore (1)    
databases (1)    
ddl triggers (1)    
grant (1)    
idle (1)    
indicators (1)    
kpi (1)    
latch waits per sec (1)    
lock waits per sec (1)    
logouts (1)    
migration (1)    
mirroring (1)    
number of deadlocks per sec (1)    
page life expectancy (1)    
page splits (1)    
password policy (1)    
perfmon (1)    
performance tuning (1)    
powershell (1)    
scripting (1)    
sp_help_revlogin (1)    
sql server 2005 (1)    
total latch wait time (1)    
t-sql (1)    
user logins (1)    
user permissions (1)