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 > 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.