x

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

avatar image

nidheesh.r.pillai
9.5k 23 59 49

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

The question has been closed May 10 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 at 11:17 AM

avatar image

Kev Riley ♦♦
66.1k 48 63 81

Awesome! That answers.

Jan 11 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x122
x108
x7

asked: Jan 11 at 10:53 AM

Seen: 1308 times

Last Updated: Jan 11 at 12:33 PM

Copyright 2017 Redgate Software. Privacy Policy