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
Hi,
You have to be granted sysdba privilege to do so!
To achieve that do the following:
> svrmgrl
> connect sys as sysdba
> password: oracle
> grant sysdba to <your DBA user>;
> quit
To be able to grant privileges when you have connected sys or system as sysdba
you have to set up a password file.
Please, contact me if you don't know how to do it.
Good Luck!
Alex
"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message
news:39787d6a.6145064_at_news-server...
> 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 Wed Jul 26 2000 - 00:00:00 CDT