July 25, 2008 at 8:20 am
In SQL SERVER 2005, there is an explicit permission simply named ALTER. Could someone tell me the scope of this permission? Does it mean ALTER TABLE, ALTER STORED PROCEDURE, etc?
Thanks!
July 25, 2008 at 9:16 am
You need to specify what you granting ALTER to like:
Grant Alter On schema::dbo TO user/role, etc...
This is new because SQL Server 2005 has changed syntax for users, roles, etc... to use CREATE, ALTER, DROP just like on other objects. So you changing a login is done using ALTER login_name so you need ALTER LOGIN permissions.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 25, 2008 at 9:44 am
Just so I understand, simply checking the Grant box for ALTER is not sufficient for granting the user permissions to execute ALTER TABLE statements or ALTER PROCEDURE statements or altering any other object?
July 25, 2008 at 9:51 am
The permission is specific to object you are selecting grant on. If I have a table users and I am Granting ALTER to that table to user1 then user1 can run ALTER users add new_column int not null only on that table.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply