000030905 - RSA VIA L&G / IMG / Aveksa - Object type OBJECT_GRANT failed to create with error

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000030905
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.5.1
Product Description: Access Certification Manager
IssueWhen restoring a backup you receive the error similar to:
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'AVUSER_RO' does not exist
CauseThis issue can occur if in the source system you had added an additional database user for reporting, read only access, or some other purpose.
ResolutionTo be able to restore the backup, the user reference in the portion of the error "user or role 'AVUSER_RO' does not exist" must be created and then the restore can be re-attempted.
To add the user using the AVUSER_RO as an example:
su - oracle
sqlplus / as sysdba
CREATE USER AVUSER_RO identified by secret;
exit
In this example the AVUSER_RO user is created and given a password of secret.
Now the restore should be able to complete and will be able to create the tables and views with rights for AVUSER and the additional user you added.

Attachments

    Outcomes