locked
Owner Authority on a DB RRS feed

  • Question

  • Server info: SQL 2008 R2

    ERROR: When users try to run the following commands

     

    This is what I have done so far:

    Database Created: VcenterTP_DB

    DB User created on the SQL Server: vcentertp  The default database is VcenterTP_DB

    Created a schema in VcenterTP_DB database: VMW

    Tried to Assign the default schema VMW to the user vcentertp.  Not able to do that, I get errors. Since vcentertp is the owner of that DB

    I am being told that user needs system wide procedure permissions.  I would appreciate any help.

    Thanks.



    Tuesday, February 17, 2015 5:18 PM

Answers

  • This issue occur due to lack of privilege on SQL server.When installing vcenter server you need to connect to the sql server with a user that have db owner permission on master and msdb database to create the stats rollup tasks.So create a user that have db_owner permission on master and msdb database.
    • Proposed as answer by pituachMVP Tuesday, February 17, 2015 7:37 PM
    • Marked as answer by AIM28256 Tuesday, February 17, 2015 8:52 PM
    Tuesday, February 17, 2015 5:34 PM
  • Yes...you can go to SQL instances-->security-->logins(already existing)-->properties-->user mapping and grant the privilege.

    If you feel this answer is helpful you mark it as answer.

    • Marked as answer by AIM28256 Tuesday, February 17, 2015 8:51 PM
    Tuesday, February 17, 2015 5:49 PM
  • It looks like the user might need permission to create/delete and execute sql jobs.

    So don't take off the permission.

    --Prashanth


    Tuesday, February 17, 2015 8:55 PM
    Answerer

All replies

  • This issue occur due to lack of privilege on SQL server.When installing vcenter server you need to connect to the sql server with a user that have db owner permission on master and msdb database to create the stats rollup tasks.So create a user that have db_owner permission on master and msdb database.
    • Proposed as answer by pituachMVP Tuesday, February 17, 2015 7:37 PM
    • Marked as answer by AIM28256 Tuesday, February 17, 2015 8:52 PM
    Tuesday, February 17, 2015 5:34 PM
  • Thank you so much for your help.

    Do I need to go to security on the server and give that user DB_OWNER on Master and MSDB?

    Tuesday, February 17, 2015 5:41 PM
  • Yes...you can go to SQL instances-->security-->logins(already existing)-->properties-->user mapping and grant the privilege.

    If you feel this answer is helpful you mark it as answer.

    • Marked as answer by AIM28256 Tuesday, February 17, 2015 8:51 PM
    Tuesday, February 17, 2015 5:49 PM
  • Thank you for your help.

    I have made the change per your suggestion. I am waiting for the user to do the testing and I will let you know the result.

    Tuesday, February 17, 2015 6:14 PM
  • Problem resolved. Thanks for your help.

     User has confirmed that he is able to run the commands.  

      Do I need to remove MSDB owner permission later? 

      Thanks.

    Tuesday, February 17, 2015 8:51 PM
  • It looks like the user might need permission to create/delete and execute sql jobs.

    So don't take off the permission.

    --Prashanth


    Tuesday, February 17, 2015 8:55 PM
    Answerer
  • Thank you Sir.
    Friday, February 20, 2015 2:25 PM