July 22, 2011 at 9:47 am
Shark Energy (7/22/2011)
cengland0 (7/22/2011)
Hey, wait a second. According to:http://technet.microsoft.com/en-us/library/bb510667.aspx
Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies on the system. This control includes creating and editing policies and conditions and enabling and disabling policies.
So tell me why did I get it wrong?
As well as the decent explanation you've already been given, the option in the question was actually PolicyAdministrator rather than the correct role name of PolicyAdministratorRole
There was that part too:-D
Glad to see you caught that
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 9:49 am
I am somewhat intrigued to see that so far only 19% of respondents have answered correctly.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 10:02 am
calvo (7/22/2011)
cengland0 (7/22/2011)
Hey, wait a second. According to:http://technet.microsoft.com/en-us/library/bb510667.aspx
Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies on the system. This control includes creating and editing policies and conditions and enabling and disabling policies.
So tell me why did I get it wrong?
He mentions testing the alert before pushing to production which indicates an on-demand test. Reading further in the link you'll see
"Alert security:
When policies are evaluated on demand, they execute in the security context of the user. To write to the error log, the user must have ALTER TRACE permissions or be a member of the sysadmin fixed server role. Policies that are evaluated by a user that has less privileges will not write to the event log, and will not fire an alert."
Although sysadmin will work, it's not the minimum permission 🙁
BOL also says: Alerts are raised only for policies that are enabled. Because On demand policies cannot be enabled, alerts are not raised for policies that are executed on demand.
that means no alert will be raised when execute policy on demand. am I missing something?
Great question and discussion BTW.
July 22, 2011 at 8:33 pm
"PolciyAdministrator is not a role in the msdb database"
Almost half of the people thought it was a role :w00t:
So very good question! Thanks!
July 23, 2011 at 1:18 am
tough one for my midnight snack. : )
--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.
July 25, 2011 at 10:43 am
tilew-948340 (7/22/2011)
"PolciyAdministrator is not a role in the msdb database"Almost half of the people thought it was a role :w00t:
So very good question! Thanks!
Thank you
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 25, 2011 at 1:39 pm
I need to reread the question before answering, I missed the at minimum and went with sysadmin fixed server role.:w00t:
July 26, 2011 at 3:17 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 31 through 37 (of 37 total)
You must be logged in to reply to this topic. Login to reply