A DW Base Schemes owner ?

Верещака Андрій 25 Reputation points
2024-11-19T09:17:38.68+00:00

Hi ! Recently we've got a strange issue on our SCOM SQL DWH server - a lot of errors kind of "Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself". Our DBA made some investigation and a result was a little bit tricky. This messages were raised, because our DAS user tried to grant rights to the Perf scheme, where he had already had ownership )))) throughout the OpsMgrWriter role. We changed ownership of the Perf scheme to dbo and that cured the issue ))) Newertheless we've checked out all the schemes in the OperationsManagerDW base and some inneresting thing we found out . All the schemes there has as an owner the same OpsMgrWriter role )))))) instead of dbo

My question is - Is that right that all the schemes in the OperationsManagerDW base have the OpsMgrWriter role as an owner ? Should we change it to dbo (like we has done with the Perf scheme in order to avoid errors)?

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,507 questions
0 comments No comments
{count} votes

Accepted answer
  1. XinGuo-MSFT 19,696 Reputation points
    2024-11-20T02:18:59.5533333+00:00

    Hi,

    Regarding your question, it's not typical for all schemas in the OperationsManagerDW database to have the OpsMgrWriter role as the owner. Generally, the dbo (database owner) should own the schemas to avoid permission issues like the ones you've encountered.

    Changing the ownership of the schemas to dbo, as you did with the Perf schema, is a good approach to prevent these errors. However, before making any changes, it's always a good idea to:

    Backup your database: Ensure you have a recent backup in case anything goes wrong.

    Please attempt to repair the Operations Manager installation by rerunning the Operations Manager Setup wizard.

    User's image

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.