Re: Get database name in OCI or Transact-SQL

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 3 Oct 2002 10:50:12 +1000
Message-ID: <PjMm9.45069$g9.128528@newsfeeds.bigpond.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:R4Mm9.45057$g9.128496_at_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.

Oh golly gosh

I mean can't, can't grant select on the synonym ...

Richard
>
> Cheers
>
> Richard
>
>
>
Received on Wed Oct 02 2002 - 19:50:12 CDT