Re: PL/SQL Problem

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.

>
>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:22:15 CDT