Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Permissions Rss

Search for any content tagged permissions

   Items 1 to 16 of 16   

SQL Server Access Control: The Basics

No technology yet invented can in any way allow us to neglect the task of ensuring the security of the database by controlling access. Security must be applied in depth, and the database is designed provide a system that will thwart even the most determined external attack. If it seems a bit complicated at first, that is no longer an excuse now that Rob Sheldon has provided this simple guide for getting started.  Read more...
By Additional Articles 2016/08/25 | Source: SimpleTalk | Category: simple talk
Rating:  Rate this |   Briefcase | 7,205 reads

Find Permission Changes In The Default Trace

Learn how to find who has changed permissions from the default trace   Read more...
By Lori Brown 2015/10/13 | Source: | Category: permissions
Rating: |  Discuss |   Briefcase | 2,038 reads

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: | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,527 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: | Category: security
Rating: |  Discuss |   Briefcase | 6,158 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: | Category: permissions
Rating: |  Discuss |   Briefcase | 7,297 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: | Category: security
Rating:  Rate this |   Briefcase | 2,829 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: | Category: permissions
Rating:  Rate this |   Briefcase | 4,273 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: | Category: automation
Rating: |  Discuss |   Briefcase | 5,002 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: | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 3,224 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,624 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: | Category: permissions
Rating:  Rate this |   Briefcase | 4,728 reads

Analyzing SQL Server Permissions

This article shows the steps to analyze SQL Server logins and permissions to ensure that there are no logins and users that exist who are have unnecessary access  Read more...
By Additional Articles 2009/03/17 | Source: SQL Server Performance | Category: auditing
Rating:  Rate this |   Briefcase | 3,177 reads

CONTROL SERVER vs. sysadmin membership

In a previous blog post on Detecting When a Login Has Implicit Access to a Database, I mentioned that having CONTROL SERVER rights means having implicit rights into the databases. Robert Davis posted a comment asking if there was a difference with respect to explicit permissions between being a member of the sysadmin fixed server role and having CONTROL SERVER rights.  Read more...
By Brian Kelley 2009/03/16 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,215 reads

Proxy Accounts in SQL Server

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them  Read more...
By Additional Articles 2008/12/30 | Source: Database Journal | Category: proxy accounts
Rating: (not yet rated)  Rate this |   Briefcase | 3,858 reads

How do I assign permissions to users to see SQL Agent Jobs?

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server  Read more...
By Additional Articles 2008/12/16 | Source: | Category: security
Rating:  Rate this |   Briefcase | 3,089 reads

Granting View Definition Permission to a User or Role

Instead of granting higher level permissions, is there a way to allow users that only have public access the ability to see object definitions?  Read more...
By Additional Articles 2008/10/13 | Source: | Category: security
Rating:  Rate this |   Briefcase | 3,479 reads
   Items 1 to 16 of 16