|
|
Oracle Database 12.1.0.2
Hello Erman,
I have imported a dump file. I created all users required by the dump.
But I see Oracle reports some users not found. They are indeed present on DB.
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_GAS_RW' does not exist
Failing sql is:
GRANT "GOLD_GAS_RW" TO "GOLD_GAS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_GAS_RO' does not exist
Failing sql is:
GRANT "GOLD_GAS_RO" TO "GOLD_GAS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'UMAPWALLET_RW' does not exist
Failing sql is:
GRANT "UMAPWALLET_RW" TO "UMAPWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'UMAPWALLET_RO' does not exist
Failing sql is:
GRANT "UMAPWALLET_RO" TO "UMAPWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'MSGFEEDPNS_RW' does not exist
Failing sql is:
GRANT "MSGFEEDPNS_RW" TO "MSGFEEDPNS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'MSGFEEDPNS_RO' does not exist
Failing sql is:
GRANT "MSGFEEDPNS_RO" TO "MSGFEEDPNS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'HKTWALLET_RW' does not exist
Failing sql is:
GRANT "HKTWALLET_RW" TO "HKTWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'HKTWALLET_RO' does not exist
Failing sql is:
GRANT "HKTWALLET_RO" TO "HKTWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_WALLET_RO' does not exist
Failing sql is:
GRANT "GOLD_WALLET_RO" TO "GOLD_WALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_WALLET_RW' does not exist
Failing sql is:
GRANT "GOLD_WALLET_RW" TO "GOLD_WALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_RW' does not exist
Failing sql is:
GRANT "GOLD_MPP_RW" TO "GOLD_MPP"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_RO' does not exist
Failing sql is:
GRANT "GOLD_MPP_RO" TO "GOLD_MPP"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MSG_FEED_RW' does not exist
Failing sql is:
GRANT "GOLD_MSG_FEED_RW" TO "GOLD_MSG_FEED"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MSG_FEED_RO' does not exist
Failing sql is:
GRANT "GOLD_MSG_FEED_RO" TO "GOLD_MSG_FEED"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_SHADOW_RW' does not exist
Failing sql is:
GRANT "GOLD_MPP_SHADOW_RW" TO "GOLD_MPP_SHADOW"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_SHADOW_RO' does not exist
Failing sql is:
GRANT "GOLD_MPP_SHADOW_RO" TO "GOLD_MPP_SHADOW"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPS_RW' does not exist
Failing sql is:
GRANT "GOLD_MPS_RW" TO "GOLD_MPS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPS_RO' does not exist
Failing sql is:
GRANT "GOLD_MPS_RO" TO "GOLD_MPS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_BPM_RW' does not exist
Failing sql is:
GRANT "GOLD_BPM_RW" TO "GOLD_BPM"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_BPM_RO' does not exist
Failing sql is:
SQL> create role GOLD_GAS_RW;
create role GOLD_GAS_RW
*
ERROR at line 1:
ORA-01921: role name 'GOLD_GAS_RW' conflicts with another user or role name
Kindly advise.
Regards,
Roshan
|
Locked
