I'm a bit confused about permissions. If a user, User1, belong to multiple groups, say
ADGroup1 --> SQLGroup2 --> SELECT permission on Table1, Table2 in DB1
ADGroup2 --> SQLGroup3 --> INSERT/UPDATE permission on Table1 and Table3 in DB1
ADGroup3 --> SQLGroup9 --> VIEW Definition to DB3
In this case, what permission the User1 has it? I think all of it since this user is part of those 3 AD groups and these AD groups are member of SQL groups that the permissions have been set.
Is this right or is there something that I missed?