Post reply

DB Roles

  • November 4, 2013 at 12:02 am

    #395771

    Dear All

    Need to create 3 users, please guide what roles to selected for these users

    1. User who can run DDL commands

    2. User who can excute procedures/views/triggers, view/add/delete/modify data

    3. User who can take back up

    Regards

  • November 4, 2013 at 4:47 am

    #1663775

    Krishna1 (11/4/2013)

    Dear All

    Need to create 3 users, please guide what roles to selected for these users

    1. User who can run DDL commands

    2. User who can excute procedures/views/triggers, view/add/delete/modify data

    3. User who can take back up

    Regards

    There are built roles for this (with the exception of executing procs and funcs, etc) and they are

    1. db_ddladmin

    2. db_datareader and db_datawriter

    3. db_backupoperator

    For the following

    2. User who can excute procedures

    You could grant execute at the schema level but this may be overkill, a custom db role with the appropriate permissions granted might be better

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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