I have user c##admin in my core DB (Oracle 19c), with "sysdba" privileges.
I want it to select from a pdb using a database link without giving a password.
assuming the following:
- PDB Name: PDB_TEST
- Schema Name: TEST
- Table Name: TABLE1
This is the database link:
CREATE DATABASE LINK TEST_DBLINK USING 'PDB_TEST'
Assuming I want to run the following query:
select * from "TEST"."TABLE1"@TEST_DBLINK;
When I'm connected to c##admin as sysdba, the query runs and returns the results.
When I connected to c##admin (not as sysdba) or when I run it from a scheduled job it failed with the following error:
> ORA-01017: invalid username/password; logon denied
So, my question is: can I run a scheduled job as sysdba?
BTW: A NO is also an acceptable answer.