<div>
Are you referring to GRANT ALTER ON objectname?<br />
If so means that the user will be allowed to make changes on the object.<br />
If a table then he can drop, add or modify columns.<br />
If a view then he can change the view definition.<br />
If a function or stored procedure he can change the code.
</div>


Are you referring to GRANT ALTER ON objectname?
If so means that the user will be allowed to make changes on the object.
If a table then he can drop, add or modify columns.
If a view then he can change the view definition.
If a function or stored procedure he can change the code.

<div>
No, in sql server there is an 'alter settings' option you can grant &nbsp;like Grant alter settings to [&lt;prinsiple&gt;] &nbsp;the ssms screen shot of the property I am talking about. image attached.<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/05_w21/914793/C--Users-wminson-Pictures-properties.png" target="_blank" class="file-inline" title="sql ssms 2014 properties (35 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>C--Users-wminson-Pictures-properties.png</a>
</div>


No, in sql server there is an 'alter settings' option you can grant  like Grant alter settings to [<prinsiple>]  the ssms screen shot of the property I am talking about. image attached.
C--Users-wminson-Pictures-properties.png [https://filedb.experts-exchange.com/incoming/2015/05_w21/914793/C--Users-wminson-Pictures-properties.png]

C--Users-wminson-Pictures-properties.png

<div>
I see. That means who have rights on ALTER SETTINGS can change any setting for the current SQL Server instance.<br />
Basically you give permission to someone to execute the <a href="https://msdn.microsoft.com/en-us/library/ms188787.aspx" rel="ugc">sp_configure</a>.
</div>


I see. That means who have rights on ALTER SETTINGS can change any setting for the current SQL Server instance.
Basically you give permission to someone to execute the sp_configure [https://msdn.microsoft.com/en-us/library/ms188787.aspx].

<div>
reson I ask is we have not seen or noticed this option until we went to ssms 2014
</div>


reson I ask is we have not seen or noticed this option until we went to ssms 2014

<div>
You can find that at least in SQL Server 2008R2. I don't have any previous version here so I can't confirm for SQL Server 2005.
</div>


You can find that at least in SQL Server 2008R2. I don't have any previous version here so I can't confirm for SQL Server 2005.

<div>
<div class="content wysiwyg-content">
What are the implications of using the grant Alter Settings permission in SQL server?<br />
&nbsp;I have been having a hard time finding information on this.
</div>
</div>


What are the implications of using the grant Alter Settings permission in SQL server?
 I have been having a hard time finding information on this.

What are the implications of using GRANT Alter Settings

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.