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

Content with tag Roles Rss

   Items 1 to 11 of 11   
 

View My Definition

By Andy Warren 2014/03/07 | Category: roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,777 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,430 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,209 reads

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2013/11/04 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,756 reads

The User Defined Server Roles in SQL Server 2012

This article describes how to create user defined server roles and use stored procedures and queries related.  Read more...
By Daniel Calbimonte 2012/05/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,490 reads

New User-defined Server Roles in SQL Server 2012

SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.  Read more...
By Additional Articles 2012/02/29 | Source: Database Journal | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,425 reads

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...
By Eric Russell 2012/02/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,565 reads

Public Role and Security

Having flown a fair amount lately, I was thinking about the various levels of security within an airport. ┬áPart of...  Read more...
By 2011/12/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,570 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,430 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,430 reads

Database Users And Associated Database Roles

This script basically retreives all database users thier database roles for a database.   Read more...
By Larry Sumuri 2010/02/10 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 3,239 reads
   Items 1 to 11 of 11   
 
Tags
security (8)    
permissions (4)    
logins (3)    
auditing (2)    
comparison (2)    
members (2)    
ownership (2)    
principals (2)    
role (2)    
secure (2)    
sql server 2012 (2)    
user (2)    
administration (1)    
blogs (1)    
grant (1)    
server roles (1)    
server_principals (1)    
sysadmin (1)    
users (1)    
xp_logininfo (1)