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 9:57 am

    #771861

    Judy (1/25/2008)

    Hi all,

    How can I grant one user to have db_owner permission on some tables , but only have db_datareader permission on others tables.

    Thanks

    db_owner is a database role and basically means you have all database level options. You can not give it to specific objects with in a database. Sounds like you need a custom database role that gives permissions appropriately to different objects.