MO_GLOBAL execute issue

[VinodN]

Hi Erman, can a custom user execute MO_GLOBAL.INIT in 12.2? We have a custom user - READONLY. We granted execute on mo_global to this user. But the user is not able to execute it. Is there any way to achieve this?

[ErmanArslansOracleBlog]

by reviewing the code of MO_GLOBAL, you may achieve what you need.. (see the necessary privileges..)

But see -> Executing mo_global.set_policy_context from Custom User Fails with Error "ORA-00942" and "ORA-06512" (Doc ID 2983009.1) -- READ the solution.

[VinodN]

Thanks Erman!