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_at_newsfeeds.bigpond.com>
Date: Thu, 3 Oct 2002 10:34:14 +1000
Message-ID: <R4Mm9.45057$g9.128496_at_newsfeeds.bigpond.com>
[Quoted] "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 Thu Oct 03 2002 - 02:34:14 CEST