What are the implications of using GRANT Alter Settings

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.
Ward MinsondeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
Ward MinsondeveloperAuthor Commented:
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
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Ward MinsondeveloperAuthor Commented:
reson I ask is we have not seen or noticed this option until we went to ssms 2014
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
Olaf DoschkeSoftware DeveloperCommented:
ALTER SETTINGS

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

Found elsewhere. It's also a securable in SQL2005, but of course the client tools, especially management studio and drivers have to know and support this to see it there.

Bye, Olaf.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ward MinsondeveloperAuthor Commented:
Explains the role
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.