Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Denied Seconary DBA to Policy Management

Author  Topic 

sg2255551
Constraint Violating Yak Guru

274 Posts

Posted - 2010-08-10 : 09:33:15
hi

how i do deny secondary dba to policy management? is there a way? Thanks

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-17 : 05:06:35
check the BOL entry: Policy-Based Management, administering

Under Security, it tells you the minimum permission required to create, modify and remove policies and how it is elevated

basically, if the secondary DBA is sysadmin, you can't deny him/her

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -