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

Home -> Community -> Mailing Lists -> Oracle-L -> Database role BECOME USER

Database role BECOME USER

From: Bert van der Plas <bvanderplas_at_hmc-heerema.com>
Date: Fri, 14 Jul 2000 11:13:35 +0200
Message-Id: <10558.112030@fatcity.com>


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 #
########################################
Received on Fri Jul 14 2000 - 04:13:35 CDT

Original text of this message

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