Re: Misleading "view" ALL_JOBS - really a synonym to USER_JOBS

AFAIK, only the user who submitted the job can perform operations on it. Even a user with the DBA privilege cannot remove another users job. So ALL_JOBS seems redundant to me.

Joe Belka.

"Vsevolod Afanassiev" <vafanassiev_at_aapt.com.au> wrote in message news:4f7d504c.0106020234.1e968812_at_posting.google.com...
> Normally, ALL_something, DBA_something, and USER_something are 3
> different views, but not for jobs (DBMS_JOBS).
> Look in $ORACLE_HOME/rdbms/admin/catjobq.sql:
> create public synonym ALL_JOBS for USER_JOBS
> Isn't it a bit misleading? In one of our applications
> user A submits a job and user B removes it by selecting from
> ALL_JOBS - naturally it does not work.
Received on Sat Jun 02 2001 - 09:02:55 CDT