Re: Get database name in OCI or Transact-SQL

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 3 Oct 2002 10:34:14 +1000
Message-ID: <R4Mm9.45057$g9.128496@newsfeeds.bigpond.com>

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D9B0F11.C4E8CE6A_at_exesolutions.com...

... snip ...

> It is not true that you need to be a DBA to see v$ tables.
>
> If you truly need this information then your DBA will grant you the
privilege.
> Ask them to do the following:
>
> GRANT SELECT ON v$... TO <your schema_name>
>
> If they don't then you likely didn't need the information.
>
> Daniel Morgan
>

Slight correction.

GRANT SELECT ON v_$... TO <your schema_name>

                                    ......

You can grant the select on the synonym.

Cheers

Richard Received on Wed Oct 02 2002 - 19:34:14 CDT