Granting permission on SP

Question

Post reply

Granting permission on SP

sql1971

SSC Enthusiast

Points: 172
More actions
June 10, 2003 at 9:54 am

#82637

Hi I have created new user in SQL 2000 db and want to assign him only permissions to Create/ALTER proc nothing else but I am not able to do that as I can give him create proc permission but I don't see any alter proc permission alone.
Thanks for response.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

As long as he has the create permission and own the objects, He will be able to alter it too.

sql1971 SSC Enthusiast Points: 172 More actions · Answer 2

I tried using this login but not able to alter it as it says permission denied. It is able to create new proc.

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

ALTER PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the owner of the procedure, and are not transferable.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

quote:
ALTER PROCEDURE permissions default to members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the owner of the procedure, and are not transferable.

Wouldn't it be sufficient to add the user to db_ddl_admin role on that db's that he needs?

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

sql1971 SSC Enthusiast Points: 172 More actions · Answer 5

You are right Frank but this will give him permission to change any defition he wants, I wanted to limit it to certain objects.

Thanks for response.

Granting permission on SP

Cookies on SQLServerCentral