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:16 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
Kwex (7/22/2011)
Nice question! Got me researching on Alerts, Roles and Policies before I answered and got it right


Thanks - and good




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 #1146715
Posted Friday, July 22, 2011 9:17 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
Thomas Abraham (7/22/2011)
Excellent question. Thanks Jason!


My pleasure




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 #1146716
Posted Friday, July 22, 2011 9:17 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 10:45 AM
Points: 3,266, Visits: 1,959
Nice question. Missed it and learned something. Thanks
Post #1146717
Posted Friday, July 22, 2011 9:17 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
Britt Cluff (7/22/2011)
Thanks for the question.


You're welcome




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 #1146718
Posted Friday, July 22, 2011 9:18 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
stewartc-708166 (7/22/2011)
This was quite a headscratcher.
thanks, Jason, learned something today.


Woohoo - goal accomplished then




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 #1146719
Posted Friday, July 22, 2011 9:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 1,380, Visits: 2,684
Good Question. Thanks! I over guessed it and should of stuck with my first thought.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #1146731
Posted Friday, July 22, 2011 9:40 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
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?


Two different facets of PBM. This question was in regards to alerting and the "minimium" security required to test an alert. Administering policies can be accomplished by membership in PolicyAdministratorRole, but to test alerts one must at a minimum have "Alter Trace" permissions.

Also, PolicyAdministratorRole does not appear to have Alter Trace permissions.

Try:
SELECT * FROM sys.fn_builtin_permissions ('server')

sp_helprotect NULL,'PolicyAdministratorRole'

Alter Trace is a "Server" class permission and is covered by the "Control Server" permission. So it may be misleading in the article to say that this role can fully administer PBM. What it really means is that this role can create and edit policies but not test alerts associated to those policies.




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 #1146742
Posted Friday, July 22, 2011 9:42 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
sharath.chalamgari (7/22/2011)
i was not thinking about the least previlages and selected the sysadmin role. thanks for the good question.


You're welcome




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 #1146746
Posted Friday, July 22, 2011 9:43 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
cfradenburg (7/22/2011)
Execute as user is made up? It actually does exist but my guess was that it couldn't be used when executing policies.

BOL reference:
Execute As (Transact-SQL)


Yeah - I worded that poorly. Made up for this question as simply an invalid choice.




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 #1146749
Posted Friday, July 22, 2011 9:45 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
SanDroid (7/22/2011)
crafdenberg (7/22/2011)
Execute as user is made up? It actually does exist but my guess was that it couldn't be used when executing policies.

BOL reference:
Execute As (Transact-SQL)


Uh Oh... maybe I spoke to soon. I totaly missed the explination saying this was made up.
"Execute As" is definately a real thing!
"Execute As" is also definately not a permission!

You might be able to use this to test the Policy Alert if the User supplied has the ALTER TRACE permission. I realy have no way to test at this time....
Did you try this crafdenberg? If you can post some working script it would prove your point, but it would not make this command a permission.


But since the question is asking for minimum permission "execute as" is not a permission and thus an invalid choice. 'Execute as' is an execution context.




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 #1146754
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse