Effective Permissions

[bikerboy718]

I am testing a user group that exists on a server. I have granted the group permissions to access the database but when I try to create a certificate for the user group I get prompted with an error message. I have local users with the same permissions as the user group which have no problem. When I checked the database permissions the User Group was listed with the permission to "Connect SQL" granter "SA" (the same as the users that work.) I selected "Effective Permissions" and get the following error message:

Cannot execute as the server principle because the principle "Citcom\Simpsons" does not exist, this type of principle cannot be immpersonated, or you do not have permissions. (Microsoft SQL Server, Error: 15406)

Any help is greatly appreciated.

With Great Power Comes Great Responsibility!!!

Michael

 

[mrdenny]

You can't pull effective permissions on a group as groups can't be immpersonated.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[bikerboy718]

If that is the case does this have anything to do with me not being able to create a certificate for a group?

With Great Power Comes Great Responsibility!!!

Michael

 

[mrdenny]

It shouldn't.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com