Post reply

Granting permission on SP

  • 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.

  • June 10, 2003 at 10:08 am

    #460613

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

  • June 10, 2003 at 10:20 am

    #460616

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

  • June 10, 2003 at 11:36 am

    #460627

    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.

  • June 11, 2003 at 4:56 am

    #460725

    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]

  • June 11, 2003 at 12:40 pm

    #460867

    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.

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

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