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