Post reply

Granting ALTER to a role on DBO objects

  • February 10, 2004 at 9:24 pm

    #161617

    Hi!

    I was trying to grant 'alter view', 'alter table','alter procedure' to a custom role but it's giving me this message. I can grant 'create' permissions but what I want is to let a developer alter objects owned by dbo in a development db.
    Thanks!!
     
    Server: Msg 165, Level 16, State 2, Line 1

    Privilege ALTER TABLE may not be granted or revoked.

    Server: Msg 156, Level 15, State 1, Line 2

    Incorrect syntax near the keyword 'PROCEDURE'.

  • February 11, 2004 at 7:11 am

    #493630

    Once user has permissions to create table/view, He will be the owner of these objects and will be able to alter them.

  • February 11, 2004 at 7:27 pm

    #493734

    what if developers want to alter existing objects owned by dbo? what permission should I grant them? thanks!

  • February 12, 2004 at 6:23 am

    #493783

    If you assign them the db_ddladmin role they can alter objects owend by dbo. It will promt them with a warning but thats all.

Viewing 4 posts - 1 through 3 (of 3 total)

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