What are the New Permissions added in SQL Server 2011 (Denali)

Posted by Mahesh Gupta on December 1, 2010 Leave a comment (0) Go to comments

Following are the New Permissions added in SQL Server Denali.

  • Alter any availability group
  • Alter any Server Role
  • Create availability Group
  • Create Server Role

What are the New Permissions added in SQL Server 2011 (Denali) what are the New Permissions added in SQL Server denali what are the New Permissions added in SQL Server 2011 SQL Server denali permissions SQL Server 2011 permissions Permission Create Server Role Permission Create availability Group Permission Alter any Server Role Permission Alter any availability group Create Server Role Create availability Group Alter any Server Role Alter any availability group

  • Alter any availability group : User assigned with permission will be alter/modify to create availability groups for high availability.
  • Alter any Server Role : User assigned with permission will be able to alter Server roles
  • Create availability Group : User assigned with permission will be able to create availability groups for high availability.
  • Create Server Role : User assigned with permission will be able to create Server roles
    • All Blog Posts, DBA, Popular, Security, SQL 2012, SQL 2012 New Features, , , , , , , , , , , ,
    EOF - What are the New Permissions added in SQL Server 2011 (Denali), SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    *

    CAPTCHA Image

    *


    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    Notify me of followup comments via e-mail. You can also subscribe without commenting.