Hello,
We have a ‘super user’ in the business who wishes to view all background jobs; however currently can only see jobs submitted by themselves.
I know by granting system privilege ADMINISTRATOR would enable this, however it would also give them too much access.
Is there a way of allowing them to view all background jobs without giving them full admin access?
They also wish to view scheduled database tasks...so same question will apply to this area
We are using Apps 8.
Regards
Shaun
Best answer by NickPorter
As noted already, this cannot be done natively in the application, but it could be handled by granting access to the underlying tables/views through something like an IAL.
Here’s a modified version of an approach that was well described by
GRANT SELECT ON ifsapp.deferred_job TO ifsinfo WITH GRANT OPTION;
Nick
+19considering the standard functionality, unfortunately the answer will be NO. The view itself checks whether a job is owned by current user or has ADMINISTRATOR sys privilege. You will need to create your own DB View and make a quick report from this view. But be careful to grant it only to this specific user.
+15As Rusiru has just mentioned - its coded in the view to need the ADMINISTRATOR privilege
WHERE (
(( SELECT Security_SYS.Has_System_Privilege('ADMINISTRATOR') FROM DUAL) = 'TRUE' )
OR
( username = ( SELECT nvl(rtrim(substr(userenv('CLIENT_INFO'),1,30)),user) FROM DUAL ))
)
+18As noted already, this cannot be done natively in the application, but it could be handled by granting access to the underlying tables/views through something like an IAL.
Here’s a modified version of an approach that was well described by
GRANT SELECT ON ifsapp.deferred_job TO ifsinfo WITH GRANT OPTION;
Nick
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
