will show you the tables your user PSEASYRUN owns
select * from user_tables;
after this, PSEASYRUN is allowed to select from the sysadm.ps_job table.
GRANT SELECT ON PS_JOB TO PSEASYRUN;
please see below outputSQL> select name from v$database;
Do you see the rows? Or do you get the same ORA-00942 ?
SQL> SELECT * FROM PS_JOBS;
Now try Action 1 again.
SQL>GRANT SELECT ON PS_JOB TO PSEASYRUN ;
Same goes for selecting over the databaselink:
SQL> select * from sysadm.ps_job;
a fix, logged on as sysadm will be:
SQL> select * from sysadm.ps_job@apexdb;
this will create a public synonym for sysadm's ps_jobs table.
CREATE PUBLIC SYNONYM PS_JOB FOR SYSADM.PS_JOB;