Re: Can't Grant "select"

From: Andrew Williamson <andrewweb_at_my-deja.com>
Date: Thu, 2 Dec 1999 16:14:53 -0000
Message-ID: <944151190.9954.0.nnrp-03.c30bdde2@news.demon.co.uk>

Better off actually finding out who owns the view. If it is orc and you don't have the password, then connect as a dba and alter the orc password. Then, reconnect as orc and grant all privileges to dba.

I fell into the same trap - my way of thinking is that system in oracle is equivalent to root in unix. Wrong! Because you are dba, you DON'T automatically get superuser rights to everything. You need to be given them.

Joe <Dont_at_Send.Com> wrote in message news:j9v14.214$8P1.10584_at_news1-hme0...
> Hi Thomas
> Actually it's a bit more complex, I just now run a select on All_Views
and..
> I notice that the View I created, as 'system' is owned by ORC, but I can't
> log in as ORC and I never connected as ORC as I don't have a password for
> ORC.
> So, what is going on?
>
> Thanks for your valuable time Thomas
> Joe
>
>
Received on Thu Dec 02 1999 - 10:14:53 CST