Re: DBA user, and rights on another user's schema

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/07/23
Message-ID: <397a34d6@news.iprimus.com.au>#1/1

"Vik" <viklall_at_my-deja.com> wrote in message news:8l7i1f$2a9$1_at_nnrp1.deja.com...
> I have three users in my database. A DBA account which I want to
> have all possible privileges, and two users that the DBA account
> creates.
>
> User 1 goes on to create some tables and indexes.
>
> I want (as DBA) to be able to grant access to User 2, to be able
> to read User 1's tables via select rights (and some synonyms).
>
> I can grant these as User 1, over to User 2.
>
> Shouldnt I also be able to do this as the DBA?
>

Absolutely not. The only person who can grant rights to an object is the owner of that object (or someone to whom the owner has granted those rights 'with grant option').

Regards
HJR
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Jul 23 2000 - 00:00:00 CDT