question

nidheesh.r.pillai avatar image
nidheesh.r.pillai 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?
permissionsloginuser-group
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Kev Riley avatar image
Kev Riley answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Awesome! That answers.
1 Like 1 ·