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

Content with tags Security, Database Roles Rss

   Items 1 to 7 of 7   
 

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,007 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,011 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,705 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,285 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,065 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,484 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,011 reads
   Items 1 to 7 of 7   
 
Tags
integration services (ssis) (1)    
maintenance (1)    
sql server 2005 (1)    
sql server 2008 r2 (1)    
sql server 7 (1)