[Closed] 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, 2017 at 10:53 AM in Default

avatar image

9.7k 23 59 49

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

The question has been closed May 10, 2017 at 08:50 AM by nidheesh.r.pillai for the following reason:

The question is answered, right answer was accepted

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, 2017 at 11:17 AM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

Awesome! That answers.

Jan 11, 2017 at 12:33 PM nidheesh.r.pillai
(comments are locked)
10|1200 characters needed characters left

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, 2017 at 10:53 AM

Seen: 1853 times

Last Updated: Jan 11, 2017 at 12:33 PM

Copyright 2018 Redgate Software. Privacy Policy