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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 3, 2015 2:10 PM
Points: 68, Visits: 182
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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 3, 2015 2:10 PM
Points: 68, Visits: 182
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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 4:19 PM
Points: 301, Visits: 860
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