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

Content with tags Security, Permissions Rss

   Items 1 to 20 of 24    Older >>
 

Stairway to SQL Server Security Level 4: Permissions

A permission gives a principal access to an object to perform certain actions on or with the object. SQL Server has a mind-numbingly huge number of permissions that you can grant to a principal, and you can even deny or revoke those permissions. This sounds a bit complicated, but by the end of this stairway level you’ll understand how SQL Server permissions work and how you can exert very granular control over object creation, data access, and other types of actions on database and server objects.  Read more...
By Don Kiely 2014/10/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,103 reads

New SQL Server 2014 Permissions: CONNECT ANY DATABASE

CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?  Read more...
By Edward Pollack 2014/07/29 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,364 reads

Drop Me? No, I Don't Think So

By Andy Warren 2014/05/14 | Category: login
Rating: (not yet rated) |  Discuss |   Briefcase | 2,071 reads

View My Definition

By Andy Warren 2014/03/07 | Category: roles
Rating: (not yet rated) |  Discuss |   Briefcase | 1,804 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,772 reads

Automated Permissions Auditing With Powershell and T-SQL: Part 5

If you’ve followed along to this point, and have assembled the pieces as I’ve given them to you, you’re now...  Read more...
By Tracy McKibben 2013/11/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,709 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,311 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,878 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,711 reads

Issues Determining an Individual SQL Server User's Permissions

Recently I was supporting a third party application. It queries to determine what tables it has permissions to before it proceeds with the rest of its functionality. We had implemented permissions based on the best practice of creating roles, assigning the permissions to the roles, and then making the users members of the roles. The application was querying INFORMATION_SCHEMA.TABLE_PRIVILEGES and of course didn't find any permissions directly against the user in question. We ended up granting explicit permissions to the user so the application would work, but I'm more interested in the general case. How can I determine permissions for an individual user?  Read more...
By Additional Articles 2012/08/02 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 2,592 reads

Automatically Scripting Out Permissions for Cross Environment Restores

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...
By Warren Campbell 2011/12/05 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 4,867 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,772 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,772 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,605 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,605 reads

Security Basics: Applying the Principle of Least Privilege Properly

Whenever I do a security presentation, I make sure to cover the Principle of Least Privilege. And when I do I boil it down to this very simple definition: Giving the rights to do the job. No more. No less.  Read more...
By Brian Kelley 2009/06/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,445 reads

Grant Mass permissions

Create A role and grant it a permission on a DB Schemas.  Read more...
By mobasha B 2009/04/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,233 reads

Database level permissions for SQL Server 2005 and 2008

I am new to SQL Server 2005/2008 having administered SQL Server 2000 and below. I have heard there are a lot of new permissions at the database level. What are they and what do they give rights to perform?  Read more...
By Additional Articles 2009/04/08 | Source: MSSQLTips.com | Category: permissions
Rating:  Rate this |   Briefcase | 4,362 reads

Determine Users with Permission on an Object

This script will walk the hierarchical chain of users and roles to find users with permissions on an object.  Read more...
By Charles Hawkins 2009/03/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,513 reads
   Items 1 to 20 of 24    Older >>
 
Tags
logins (4)    
roles (4)    
user (4)    
auditing (3)    
grant (3)    
principals (3)    
role (3)    
administration (2)    
blogs (2)    
comparison (2)    
jobs (2)    
members (2)    
ownership (2)    
scripting (2)    
secure (2)    
sql agent (2)    
sql server 7 (2)    
t-sql (2)    
automation (1)    
backup / restore (1)    
connect any database (1)    
databases (1)    
job (1)    
login (1)    
powershell (1)    
proxy accounts (1)    
script (1)    
securables (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 2014 (1)    
stairway series (1)