This question was
closed
by
nidheesh.r.pillai for the following reason: The question is answered, right answer was accepted
asked
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?
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.
16 People are following this question.
