Post reply

What authroities are needed for user

  • October 1, 2014 at 7:39 am

    #397438

    I want to give a SQL user authority to create tables and SP's against a DB. I have given them the db_owner role membership for the DB. What else do I need to give them?

  • October 1, 2014 at 8:20 am

    #1749408

    With DB_OWNER role a user is able to do everything within the scope of the database. This includes granting permissions to users!! For creating/altering tables and stored procedure the DB_DDLADMIN role would be enough. From the least-privelidge perspective this would be a better option compared to the DB_OWNER role.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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

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