Re: Allowing users to see oracle host_name

Seán Hennessy wrote:
>
> Hi,
>
> I want to display the host_name of the Oracle server in the 'About'
> box of my application. Of coure only SYS or SYSDBAs have access to
> V$INSTANCE, so a straight select simply won't work for most users. I
> tried to put the select in a package (on the basis that it would then
> run under the permissions of the packages creator), but Oracle
> wouldn't recognise V$INSTANCE.

Hi Seán,
You could try the following:

>create view sys.hostname as select host_name from sys.v$instance;

>grant select on sys.hostname to app_owner;

hth
Anthony Hogan Received on Wed Jul 02 2003 - 03:30:13 CDT