BRM Multischema Functionality Missing Grant After Schema Additions on BRM 7.5 PS8
Last updated on JULY 20, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 7.5.0]
Information in this document applies to any platform.
On BRM 7.5PS8, Multischema Installation
BRM multischema functionality did not worki properly after schema additions on BRM 7.5 PS8 due to missing grants. It was preventing the creation of accounts on multi schema environment.
Error as follows:
=ORA-01031: insufficient privileges
Followed the instructions in the documentation section - "Installing a Multischema System: Task List" to add new schemas to the multischema setup, a lot of grants were missing for the secondary schemas, which caused errors and failures to create a new account.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms