Re: PL/SQL Problem

In article <3b8e3b51.12588245_at_news>, nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote:
>On Thu, 30 Aug 2001 13:15:49 GMT, jeff_at_work.com (Jeff) wrote:
>
>>
>>2) I've never selected from system.dba_jobs_running... either
>>sys.dba_jobs_running or merely dba_jobs_running. Since those dba_* views
>>usually all belong to sys, you should get an error trying to select from
>>system.dba_*.
>
>In later versions of ORACLE, these views are granted to a role that is
>granted to all users, together with a public synonym. Inside PL/SQL,
>roles are disabled. Ergo, any attempt to see access these views will
>result in this error.
>
>Fix: grant access to each user and view, where needed.

My point was that his code (as written) will still cause an error, even after being granted direct rights to the view, because the view isn't an object in the system schema.

>>3) If you have been directly granted rights to this view, your procedure (and
>>its users) may access the view through your rights. However, rights granted
>>only through a role (like the DBA role) will not work. This is most likely
>>the primary part of your error.
>
>Precisely.
>
>
>Cheers
>Nuno Souto
>nsouto_at_optushome.com.au.nospam
Received on Thu Aug 30 2001 - 08:39:07 CDT