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 45    Older >>
 

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,001 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,473 reads

Server Logins

By Steve Jones 2015/05/04 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,346 reads

Prevent and Log Certain SQL Server Login Attempts

Aaron Bertrand presents a more elegant to prevent developers from attempting to log into production databases using application logins (and to log any such attempts).   Read more...
By Additional Articles 2015/04/14 | Source: MSSQLTips.com | Category: logins
Rating: (not yet rated)  Rate this |   Briefcase | 7,003 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,767 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,487 reads

Login options

By Steve Jones 2015/02/05 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,843 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,767 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,505 reads

Drop Me? No, I Don't Think So

By Andy Warren 2014/05/14 | Category: logins
Rating: (not yet rated) |  Discuss |   Briefcase | 2,151 reads

Can't See The Forest For the Logins

By Andy Warren 2014/03/28 | Category: logins
Rating: (not yet rated) |  Discuss |   Briefcase | 1,822 reads

The Unusable User

By Andy Warren 2014/03/26 | Category: logins
Rating: (not yet rated) |  Discuss |   Briefcase | 2,033 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,912 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 | 6,140 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,487 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,505 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 | 3,297 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,767 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,546 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 | 2,157 reads
   Items 1 to 20 of 45    Older >>
 
Tags
security (19)    
user (8)    
users (6)    
auditing (5)    
permissions (5)    
administration (4)    
role (4)    
roles (3)    
blogs (2)    
comparison (2)    
members (2)    
migration (2)    
ownership (2)    
powershell (2)    
principals (2)    
script (2)    
secure (2)    
sql server 7 (2)    
t-sql (2)    
account (1)    
add role (1)    
administrator (1)    
batch requests per sec (1)    
buffer cache hit ratio (1)    
capture logins (1)    
connections (1)    
cpu (1)    
create login (1)    
database authorities (1)    
database authorizations (1)    
database restore (1)    
databases (1)    
ddl triggers (1)    
delete user (1)    
drop user (1)    
grant (1)    
idle (1)    
indicators (1)    
kpi (1)    
latch waits per sec (1)    
lock waits per sec (1)    
logouts (1)    
mirroring (1)    
number of deadlocks per sec (1)    
page life expectancy (1)    
page splits (1)    
password policy (1)    
perfmon (1)    
performance tuning (1)    
permission (1)    
scripting (1)    
server roles (1)    
sp_help_revlogin (1)    
sql server 2005 (1)    
total latch wait time (1)    
user logins (1)    
user permissions (1)    
xp_logininfo (1)