Re: Is there such a thing as a "Super User" that can be created?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 30 Sep 2000 08:13:48 +0200
Message-ID: <711bts0533hv22k2a4boult92c4hinmvc6@4ax.com>

On Fri, 29 Sep 2000 15:11:37 -0400, "tjw" <toddw_at_pqsystemsREMOVETHIS.com> wrote:

>I am new to Oracle, and was wondering if there was some type of 'super user'
>that you could log in as, and grant object privileges (of objects that you
>don't own) to other users?
>
>Using version 8i.
>
>TIA.
>

There is not. The owner of the object explicitly needs to grant permission to others to administer the object. With sufficient privilege however you can create a procedure on his behalf to make the grant for you.
Of course this is a typical question covered by documentation, which apparently very few people care to read at all.

Sybrand Bakker, Oracle DBA Received on Sat Sep 30 2000 - 01:13:48 CDT