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

Content with tag Role Rss

   Items 1 to 6 of 6   
 

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 | 1,240 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 | 2,904 reads

Database Roles

By bitbucket 2009/02/23 | Category: role
Rating: (not yet rated) |  Discuss |  Briefcase | 3,262 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 shivaram challa 2008/10/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 1,028 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 shivaram challa 2008/10/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 12,989 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |  Briefcase | 9,924 reads
   Items 1 to 6 of 6   
 
Tags
security (6)    
administration (3)    
audit (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)