What group's permissions do I inherit when I login?

I am part of four groups on a sql server instance as seen below-

 account name      type     privilege mapped login name  permission path
 domain\npillai       user     admin     domain\npillai     servername\SQL_ADMIN
 domain\npillai       user     admin     domain\npillai     domain\SQL-DEV-ADMIN
 domain\npillai       user     user      domain\npillai     domain\SQL-DEV-OWNER
 domain\npillai       user     user      domain\npillai     domain\SQL-DEV-RW

When I connect to the server instance, out of the four groups, who am I actually inheriting permissions of? Are there ways to check the same?

more ▼

asked Jan 11 at 10:53 AM in Default

avatar image

9.4k 22 58 49

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

It will be a combination of them all where the permissions do not overlap. Where they do then it will be the highest.

So for example if domain\SQL-DEV-ADMIN gives you sysadmin but domain\SQL-DEV-RW only gives you datareader and datawriter, then you will have sysadmin permissions.

more ▼

answered Jan 11 at 11:17 AM

avatar image

Kev Riley ♦♦
65.2k 48 62 81

Awesome! That answers.

Jan 11 at 12:33 PM nidheesh.r.pillai
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 11 at 10:53 AM

Seen: 720 times

Last Updated: Jan 11 at 12:33 PM

Copyright 2016 Redgate Software. Privacy Policy