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

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/07/21
Message-ID: <8l89q7$d9f$1@perki.connect.com.au>#1/1

In two way you can give grants to other users 1- if you are the object OWNER
2- if grant option has been giver to you

DBA ios Not the object Owner.
Tom

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?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jul 21 2000 - 00:00:00 CDT