check out fined grained access control - SYS_CONTEXT is often used there ...
"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
news:3cad8cb8.2796976_at_news-vip.optusnet.com.au...
> Howard J. Rogers doodled thusly:
>
> >Well, to start with, I wouldn't check what I was connected to by
selecting
> >global_name. That can pretty much be set to anything you like, and
> >dynamically too. Select * from v$instance or v$database is more reliable.
> >
>
>
> Howard, have you had a look at that new stuff with SYS_CONTEXT?
> First came across it on 8.1.7. Wasn't in 8.1.6.
> Is it in 9i still?
>
> select SYS_CONTEXT("USERENV","DBNAME") from dual (or words to this
> effect)
>
> does what I mean. Cool stuff and doesn't need authorisations setup
> for v$*. Wonder if it's something that's gonna stay?
>
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Fri Apr 05 2002 - 12:06:07 CST
