Hello All,
I have one user 'ABC' which requires select access on table TEST1 at different PDB but same CDB and same server.
| | grant select on owner1.TEST1 to ABC; |
Error report -
SQL Error: ORA-01917: user or role 'ABC' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause: There is not a user or role by that name.
*Action: Re-specify the name.
user ABC needs to access data through select statement on test1.
what are various options and grants applicable in this case like DB links etc?
Thanks,
Rajneesh