Post reply

managing ddl rights on specified objects

  • October 10, 2005 at 3:58 am

    #115301

    Hi all,

    I'm working with SQL Server 2000; there's anyone who knows how to grant/revoke the alter view only or other alter privileges on specified database objects, without granting the ddl_admin fixed role to users?

    Thanks,

    Marco

     

  • October 10, 2005 at 5:33 pm

    #596410

    All of the ALTER permissions that I know of are not transferable, which means you can't grant permission to a user who is not a member of sysadmin, db_owner, or db_ddladmin.

    Greg   

    Greg

  • October 11, 2005 at 6:33 am

    #596506

    Correct.  MS is making a big deal about the added ability to do this in SQL 2005.

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

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