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

Content with tag Database Roles Rss

   Items 1 to 9 of 9   
 

Managing SSIS Security with Database Roles

SQL Server 2012 introduced the new project deployment model for Integration Services. This tip will guide you through the process of setting up security for the SSIS 2012 catalog.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,105 reads

List Database Users and their Corresponding Roles

Database Users and their Corresponding Roles and type login.  Read more...
By Venkat Kesavarapu 2013/01/28 | Source: SQLServerCentral.com | Category: database users
Rating: |  Discuss |   Briefcase | 1,757 reads

Finding Unused Database Roles

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...
By Brandie Tarvin 2012/07/24 | Source: SQLServerCentral.com | Category: database roles
Rating: |  Discuss |   Briefcase | 1,283 reads

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.  Read more...
By Ed Vassie 2011/09/08 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 5,040 reads

Retrieving SQL Server Fixed Database Roles for Disaster Recovery

We ran into a case recently where we had the logins and users scripted out on my SQL Server instances, but we didn't have the fixed database roles for a critical database. As a result, our recovery efforts were only partially successful. We ended up trying to figure out what the database role memberships were for that database we recovered but we'd like not to be in that situation again. Is there an easy way to do this?  Read more...
By Additional Articles 2011/02/23 | Source: MSSQLTips.com | Category: database roles
Rating: (not yet rated)  Rate this |   Briefcase | 2,723 reads

Understanding SQL Server 2008 R2 Fixed Database Level Roles

To easily manage the permissions in SQL Server databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals.  Read more...
By Additional Articles 2011/02/21 | Source: MSSQLTips.com | Category: sql server 2008 r2
Rating:  Rate this |   Briefcase | 3,298 reads

Implicit Permissions Due to SQL Server Database Roles

I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?  Read more...
By Additional Articles 2010/11/26 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 3,103 reads

SQL Server security: Database roles

Database roles for SQL servers can increase the security of your enterprise. Understand how to set up database roles, and learn how they function.  Read more...
By Additional Articles 2009/01/21 | Source: SearchSQLServer | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 3,503 reads

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.  Read more...
By Ed Vassie 2011/09/08 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 5,040 reads
   Items 1 to 9 of 9   
 
Tags
security (6)    
maintenance (2)    
administration (1)    
data quality (1)    
database users (1)    
integration services (ssis) (1)    
list users and roles (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)    
sql server 7 (1)    
user type of login (1)