RE: Database role BECOME USER

Move the period a bit and you have it. The DBMS_IJOB package can be used by users with certain privileges to manipulate other people's jobs in the job queue. You can check out a little bit more on it in the _Oracle Built-in Packages_ book, but the procedures in it work essentially the same as DBMS_JOB. Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gait, Christopher
Sent: Monday, July 17, 2000 3:23 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Database role BECOME USER

The BECOME_USER privilege is used for importing from a full export, so it's not what you are looking for.

You should look into using DBMS_JOB.iSubmit vs. DBMS_JOB.submit. I read somewhere that it is possible to use iSubmit to control other peoples' jobs by number which is not permitted by the Submit function. I can't lay my hands on the document right now (Gait's paper axiom: All documentation is guaranteed to be located at the farthest point from you at [a) home] | [b) work] when needed.), but a more thorough search of the Internet than I just did might turn it up for you.

Christopher Gait
Oracle DBA

(Semi)permanent address: cjgait_at_yahoo.com http://www.geocities.com/athens/3623

"Death is nature's way of saying: NEXT!"

> -----Original Message-----
> From: Bert van der Plas [mailto:bvanderplas_at_hmc-heerema.com]
> Sent: Friday, July 14, 2000 6:27 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Database role BECOME USER
>
>
> List,
>
> Does anyone has ever used the database role "BECOME USER"? If
> so, what are
> the possibilities for the user who has gotten the role?
>
> This is my case:
> In our Oracle databases we have several jobs (dbms_job) running in the
> Oracle queues. These are jobs "owned" by different users. I
> want to be able
> to change, delete and run jobs (of all users) through one
> Oracle database
> account. This is a "power" user.
>
>
> Regards,
>
> ########################################
> # Bert van der Plas
> #
> # Information Systems Department #
> # Heerema Marine Contractors, Leiden Office
> #
> # * 071-5799593
> #
> # * bvanderplas_at_hmc-heerema.com #
> # * Vondellaan 47, 2332 AA Leiden #
> ########################################
>
> --
> Author: Bert van der Plas
> INET: bvanderplas_at_hmc-heerema.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Author: Gait, Christopher
  INET: cgait_at_condor.nrl.navy.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may