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

On Thu, 20 Jul 2000 18:56:53 GMT, Vik <viklall_at_my-deja.com> wrote:

>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.

I think you have to grant the rights to a role WITH ADMIN option, then grant that role to the DBA. Or any other user. That should work.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Fri Jul 21 2000 - 00:00:00 CDT