Understanding SQL Server, Server Permissions – What and how to assign these permissions

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

SQL Server Permission : ALTER SETTINGS

Allows or Denies the ability to execute sp_configure and change settings. Also Allows or Denies the ability to execute RECONFIGURE afterwards. This permissions is granted by default to members of the serveradmin and sysadmin fixed server role.

Related Article : How to assign these SQL Server Permissions

Understanding SQL Server, Server Permissions What and how to assign these permissions SQL Server Permission how to give sql server permission

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 2324 25 26 27 28

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
All Blog Posts, Security, SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012, ,
EOF - Understanding SQL Server, Server Permissions – What and how to assign these permissions, 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.