Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Misleading "view" ALL_JOBS - really a synonym to USER_JOBS

Misleading "view" ALL_JOBS - really a synonym to USER_JOBS

From: Vsevolod Afanassiev <vafanassiev_at_aapt.com.au>
Date: 2 Jun 2001 03:34:11 -0700
Message-ID: <4f7d504c.0106020234.1e968812@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 - 05:34:11 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US