brent wrote:
>
> Ron Reidy <rereidy_at_indra.com> wrote in message news:<3C0FE585.137168D0_at_indra.com>...
> > Look at the V$INSTANCE view.
> Do you need some special permissions to do that,
> I am keep getting ORA-00942: table or view does not exist
> unless I'm logged in as the 'system' account.
>
> Is there no other way? My code may be operating in an environment
> with minimal privileges.
Look in the manuals for this view; it is owned by SYS. At the very
least, you will need to create a public synonym and grant select to
whatever users you want to have access to it.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Fri Dec 07 2001 - 20:18:19 CST
