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 «««1234

PBM Alert Expand / Collapse
Author
Message
Posted Friday, July 22, 2011 9:47 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:20 PM
Points: 21,751, Visits: 15,449
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

Glad to see you caught that




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1146757
Posted Friday, July 22, 2011 9:49 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:20 PM
Points: 21,751, Visits: 15,449
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1146761
Posted Friday, July 22, 2011 10:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 1, 2014 9:08 AM
Points: 106, Visits: 167
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.
Post #1146774
Posted Friday, July 22, 2011 8:33 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 15, 2014 8:37 PM
Points: 589, Visits: 2,437
"PolciyAdministrator is not a role in the msdb database"

Almost half of the people thought it was a role
So very good question! Thanks!
Post #1147007
Posted Saturday, July 23, 2011 1:18 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 5, 2014 3:53 PM
Points: 386, Visits: 364
tough one for my midnight snack. : )

--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.
Post #1147028
Posted Monday, July 25, 2011 10:43 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:20 PM
Points: 21,751, Visits: 15,449
tilew-948340 (7/22/2011)
"PolciyAdministrator is not a role in the msdb database"

Almost half of the people thought it was a role
So very good question! Thanks!


Thank you




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1147701
Posted Monday, July 25, 2011 1:39 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 3:14 PM
Points: 774, Visits: 1,177
I need to reread the question before answering, I missed the at minimum and went with sysadmin fixed server role.
Post #1147855
Posted Tuesday, July 26, 2011 3:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 13,735, Visits: 10,698
Great question, thanks!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1148096
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse