Re: object priviliges

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 08 Mar 1999 22:25:18 -0800
Message-ID: <36E4BECE.3DB6@oriolecorp.com>

Leonid Boitsov wrote:
>
> Hi everybody!
> Can dba-user (ORACLE version is 7.2 or higher) grant object privileges on
> other users' objects.
> (To grant dba is object privilege on every object with grant option is not
> convenient)
> Leonid Boitsov.

No, unless the DBA account has been explictly granted by the object owner the right to do so through a 'grant <privilege> on <object> to <dba account> with grant option'.
However, if the privileges were granted (by the object owner again) to a role, the DBA can grant the role to a user. You can however turn around this by, when you are a DBA, connect as anybody without knowing this anybody's password. A number of free scripts to do this are available on Internet, including on my company's site (www.oriolecorp.com).
--
Regards,

Stéphane Faroult
Oriole Corporation Received on Tue Mar 09 1999 - 00:25:18 CST