RSS

New Permission in SQL Server 2014

20 Nov
New Permission in SQL Server 2014

Hi Dears as we know SQL Server 2014 come with more new features and more improvements in the Performance today we will take about the new Feature in SQL Server 2014 in particular in SQL Server security SQL Server 2014 come with three new permission really amazing permission it will help any DBA in his work to can grant simple permission in All Databases in the server in the minimum time this operation it will not take from him one second lets go for the scenario and for the DEMO.

in SQL 2012 and we can see 31 permission whereas SQL 2014 has 34 permissions. These permissions are listed under Server properties >  permissions tab.

New Permission in SQL Server 2014:

  1. CONNECT ANY DATABASE Permission.
  2. SELECT ALL USER Securables Permission.
  3. IMPERSONATE ANY LOGIN Permission.

New permisions

 

Scenario:

Today if you have any customer or auditing company in your organization and need to give him access on your DB Server to can see all database and he can do expand for this databases plus he can read any data from this databases by new permissions in SQL Server 2014 we can do it by the fast and easy way.

DEMO :

1- Create User

USE [master]
GO
CREATE LOGIN [Mostafa] WITH PASSWORD=N’P@$$w0rd’
GO

2- CONNECT ANY DATABASE Permission.

use [master]
GO
GRANT CONNECT ANY DATABASE TO [Mostafa]
GO

3- SELECT ALL USER Securables Permission

use [master]
GO
GRANT SELECT ALL USER SECURABLES TO [Mostafa]
GO

New permisions

For this “IMPERSONATE ANY LOGIN Permission” we need to explain to you the Problem case to know what the the benefit from this new permission to can use it in your environment. for more detail go to my Post : IMPERSONATE ANY LOGIN Permission.

 
Leave a comment

Posted by on November 20, 2014 in General topics

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s