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

Content with tags Security, Role Rss

   Items 1 to 7 of 7   
 

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,704 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,426 reads

Understanding SQL Server fixed database roles

I know there are fixed database roles that come with SQL Server. How do I best use them within my installations? What should I watch out for? In this tip we will cover each of the database roles and recommendations on when to and when not to use them.  Read more...
By Additional Articles 2009/12/18 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,169 reads

Database Roles

By bitbucket 2009/02/23 | Category: role
Rating: (not yet rated) |  Discuss |   Briefcase | 3,293 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,071 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,704 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/06/19 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 10,828 reads
   Items 1 to 7 of 7   
 
Tags
administration (3)    
auditing (2)    
user (2)    
databases (1)    
ddl (1)    
grant (1)    
login (1)    
logins (1)    
msdb (1)    
permission (1)    
permissions (1)    
script (1)    
scripting (1)    
sql server 7 (1)    
t-sql (1)