A DW Base Schemes owner ?

Question

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)?

Accepted Answer

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

Share via

A DW Base Schemes owner ?

0 additional answers

Your answer