FW: Database role BECOME USER

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

Correction:

BECOME USER is not a database role but a SYSTEM PRIVILEGE

> -----Original Message-----
> From: Bert van der Plas
> Sent: Friday, July 14, 2000 11:14 AM
> To: 'Oracle List (Fatcity)'
> 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 #
> ########################################
Received on Fri Jul 14 2000 - 04:42:00 CDT