Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 Policy Management Expand / Collapse
Author
Message
Posted Wednesday, December 3, 2008 8:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Friday, July 16, 2010 6:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:56 AM
Points: 44, Visits: 153
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
Posted Friday, July 16, 2010 6:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:56 AM
Points: 44, Visits: 153
Oh, depending on the number of accounts you could identify them explicitly by name in the condition.
Post #953793
Posted Friday, April 29, 2011 3:49 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 25, 2014 8:19 AM
Points: 293, Visits: 813
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 »

Add to briefcase

Permissions Expand / Collapse