December 3, 2008 at 8:52 am
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.
July 16, 2010 at 6:12 am
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.
July 16, 2010 at 6:15 am
Oh, depending on the number of accounts you could identify them explicitly by name in the condition.
April 29, 2011 at 3:49 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply