Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sqlplus glogin setting

Re: Sqlplus glogin setting

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 29 Aug 2002 21:28:01 +0100
Message-ID: <3d6ecb0a_2@mk-nntp-1.news.uk.worldonline.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US