Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't Grant "select"
Thanks Andrew
But how does ORC grab it (become the owner) when I logged on and created it,
as System?
Andrew Williamson
> 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.
>
> AW
Received on Thu Dec 02 1999 - 10:50:10 CST