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

Content with tag Permissions Rss

   Items 1 to 20 of 36    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,112 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,365 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

Grant EXEC on all Stored Procedures to a Role

Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.  Read more...
By Peter Schott 2014/03/20 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 7,074 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,785 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,710 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,312 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,879 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,717 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,593 reads

Get Back into SQL Server After You've Locked Yourself Out

Someone, while locking down the SQL Server, removed the permissions by which the DBAs came in and administered the server. As a result, we cannot get back into SQL Server. How can we restore our access to SQL Server? Check out this tip to find out.  Read more...
By Additional Articles 2012/03/29 | Source: MSSQLTips.com | Category: permissions
Rating:  Rate this |   Briefcase | 4,005 reads

Report SQL SERVER 2005 Permissions

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...
By stumbling fish 2011/12/12 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 3,783 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,868 reads

Reverse-Engineer Database Permissions (2005 up)

This script reverse engineers SQL statements to recreate database permissions.  Read more...
By george sibbald 2011/10/24 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 2,789 reads

Retrieve Database Object permission scripts and Role members scripts

I often need to synchronize the user permission between databases. I wrote this simple query to script the sql statement to per item.   Read more...
By Gokhan Varol 2011/02/03 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 2,652 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,785 reads

Stored procedure to script out user permissions

Stored procedure to script out user permissions  Read more...
By Harsha Majety 2011/01/17 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 4,532 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,785 reads

Retrieving SQL Server Permissions for Disaster Recovery

I'm needing to audit the permissions in my databases, but I want to script them out so I have something to run in case of a recovery situation. I've got the logins, roles, and users handled, but it's the permissions that I want to extract. How can I do this easily?  Read more...
By Additional Articles 2010/11/08 | Source: MSSQLTips.com | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 2,809 reads
   Items 1 to 20 of 36    Older >>
 
Tags
security (21)    
administration (4)    
grant (4)    
logins (4)    
principals (4)    
roles (4)    
t-sql (4)    
user (4)    
auditing (3)    
blogs (3)    
ownership (3)    
role (3)    
comparison (2)    
jobs (2)    
members (2)    
scripting (2)    
securables (2)    
secure (2)    
sql agent (2)    
sql server 2005 (2)    
sql server 2008 (2)    
sql server 7 (2)    
administrator (1)    
automation (1)    
backup / restore (1)    
columns (1)    
connect any database (1)    
databases (1)    
disaster recovery (dr) (1)    
dump (1)    
job (1)    
login (1)    
maintenance plans (1)    
object permissions (1)    
powershell (1)    
proxy accounts (1)    
queries (1)    
report (1)    
script (1)    
sql server 2014 (1)    
stairway series (1)    
stored procedures (1)