Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sqlplus glogin setting
"Joe Sath" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.1030636696.1861450195@[64.94.198.252]...
<snip>
>I got error
>
> SQL> grant select on v$instance to public;
> grant select on v$instance to public
> *
> ERROR at line 1:
> ORA-02030: can only select from fixed tables/views
>
> Any suggestions?
>
> Thanks for your help
Hint.. v$instance is a synonym...
sqlplus '/ as sysdba' and grant select on the real view.
HTH. Paul Received on Thu Aug 29 2002 - 15:28:01 CDT