Jobs view is not visible to read-only account users I am the admin of one of the database, and I have created a view in SYS schema using below code which returns the status of the running jobs:

CREATE OR REPLACE VIEW CAF_DB_REFRESH AS
SELECT *
FROM all_scheduler_job_run_details
WHERE OWNER = 'CAFANALYST'
  AND log_id &gt; 2573
ORDER BY log_date;


I have created public synonym for this view and given access to read only account which will be used by all users in my team.

When they perform the following query, they are getting only column names with no rows:

select * from CAF_DB_REFRESH;


Could you please guide me what is the problem and if any special privileges required for read only account? If yes, I request you to guide which one is the best to see but not to modify by read only user.
As @Jeffrey pointed out, ALL_* view is not useful in your case. You should use DBA_* views because they show the records for all owners of the job objects.

The following sequence works just fine for me:

$ sqlplus /nolog

SQL&gt; connect / as sysdba
Connected.

SQL&gt; select distinct owner from dba_scheduler_job_run_details;

OWNER
------------------------------
EXFSYS
SPONGEBOB
SYS

SQL&gt; create or replace view sys.jcaf as
  2  select * from dba_scheduler_job_run_details
  3  where owner = 'EXFSYS';    
View created.

SQL&gt; grant select on sys.jcaf to spongebob;    
Grant succeeded.

SQL&gt; create public synonym jcaf_v for sys.jcaf;    
Synonym created.

SQL&gt; connect spongebob/passwd    
Connected.

SQL&gt; select distinct owner from jcaf_v;

OWNER
------------------------------
EXFSYS