SQL Server 2008 Policy Management

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server 2008 Policy Management

SQL Server 2008 Policy Management

Rate Topic

Display Mode

Topic Options

Author

Message

mps

Posted Wednesday, December 03, 2008 8:52 AM

Valued Member

Group: General Forum Members
Last Login: Monday, June 27, 2011 9:44 AM
Points: 51, Visits: 197

I'm trying to set up a policy to verify that only specific accounts are members of the sysadmin server role. I have successfully set up other policies, but can't see how to refer to server roles within policy management conditions.

Any ideas ? Thank you.

Post #612919

reuben.anderson

Posted Friday, July 16, 2010 6:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 8:28 AM
Points: 27, Visits: 135

Yes. Me too. The only variables you can pass into an execute string are @@objectname and @@schemaname.

Seems a strange thing to be missing also.

Post #953789

reuben.anderson

Posted Friday, July 16, 2010 6:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 8:28 AM
Points: 27, Visits: 135

Oh, depending on the number of accounts you could identify them explicitly by name in the condition.

Post #953793

Jon.Morisi

Posted Friday, April 29, 2011 3:49 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275, Visits: 679

similar here
http://www.sqlservercentral.com/Forums/Topic1100990-1550-1.aspx?Update=1

I blogged about what I did to solve the problem here
http://jonmorisissqlblog.blogspot.com/2011/04/configure-policy-to-checks-that.html

Post #1101085

« Prev Topic | Next Topic »

Permissions