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

Content with tags Security, Roles Rss

   Items 1 to 10 of 10   
 

View My Definition

By Andy Warren 2014/03/07 | Category: roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,796 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,654 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,277 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,838 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,514 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,436 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,574 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,618 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,654 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,654 reads
   Items 1 to 10 of 10   
 
Tags
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)    
xp_logininfo (1)