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


 

Content with tags Administration, Role Rss

   Items 1 to 4 of 4   
 

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shiva CHALLA 2012/12/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,561 reads

Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.   Read more...
By Shiva CHALLA 2008/10/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,068 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shiva CHALLA 2012/12/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,561 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/05/21 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 10,798 reads
   Items 1 to 4 of 4   
 
Tags
security (3)    
auditing (1)    
databases (1)    
ddl (1)    
grant (1)    
logins (1)    
permissions (1)    
script (1)    
scripting (1)    
sql server 7 (1)    
t-sql (1)    
user (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.