Effective Permissions for a group

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Effective Permissions for a group

Effective Permissions for a group

Rate Topic

Display Mode

Topic Options

Author

Message

UKT

Posted Wednesday, October 27, 2010 2:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, November 06, 2011 9:39 PM
Points: 5, Visits: 25

Version - SQL Server 2005 SP3

I have added some users to the group "PROD\SEA-SQL-READ" and gave them read access to the group. But when I click Effective permissions I get the below error.

Cannot execute as the server principal because the principal "PROD\SEA-SQL-READ" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Microsoft SQL Server, Error: 15406)

Thank you all in advance

Post #1011902

Carl Federl

Posted Wednesday, October 27, 2010 3:12 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:54 AM
Points: 2,224, Visits: 4,080

It is a bug in SQL Server 2005 Managment Studio. The fix suggested by MS is to use the SQL Server 2008 Managment Studio.

SQL = Scarcely Qualifies as a Language

Post #1011911

« Prev Topic | Next Topic »

Permissions