Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA user, and rights on another user's schema
As far as I know, the DBA user (sys, system, etc.) is not like root where you can do practically anything. You have to log in as the user and do the grants.
HTH,
Verna
"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 Thu Jul 20 2000 - 00:00:00 CDT