Home Forums SQL Server 2005 Administering How grant db_owner permission to some objects RE: How grant db_owner permission to some objects

  • January 25, 2008 at 10:28 am

    #771883

    Judy (1/25/2008)

    Actually I created one custom database role, named "db_Custom" and added objects to this new role.

    Users under this role only have "select, update, delete,insert" on objects.

    But users need to own "alter table (view)" on those specific objects and create new table permission.

    How can I implement this task?

    Check out "GRANT" in books online (http://msdn2.microsoft.com/en-us/library/ms188371.aspx)

    GRANT CREATE TABLE TO db_Custom - etc.