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

Content with tag User Rss

   Items 1 to 9 of 9   
 

The Unusable User

By Andy Warren 2014/03/26 | Category: login
Rating: (not yet rated) |  Discuss |   Briefcase | 1,817 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,102 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,609 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,202 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 2013/08/06 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 1,205 reads

Alter User

Rating: (not yet rated) |  Discuss |   Briefcase | 2,082 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 | 2,882 reads

Relationship between users and Databases

Show the users inside the databases  Read more...
By Ricardo Leka 2011/05/30 | Source: SQLServerCentral.com | Category: user
Rating: |  Discuss |   Briefcase | 2,184 reads

get users across all databases on the SQL Server instance

Quick way to get all users on all Databases  Read more...
By Mani Singh 2008/07/24 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 1,555 reads
   Items 1 to 9 of 9   
 
Tags
security (6)    
login (4)    
role (4)    
auditing (3)    
logins (3)    
permissions (3)    
administration (2)    
comparison (2)    
databases (2)    
members (2)    
ownership (2)    
principals (2)    
roles (2)    
secure (2)    
account (1)    
delete user (1)    
drop user (1)    
grant (1)    
metadata (1)    
permission (1)    
relationship (1)    
script (1)    
scripting (1)    
sql server 7 (1)    
t-sql (1)