Re: Row Level Security (8i)

Jonathan Lewis wrote:
>
> How do you know that it is being created ?

My boss directly queried the procedure that was generating the predicate and it returned the correct info.  

> Are you using a 10730 trace to dump the predicate
> or some other tool to write the predicate to disc ?

Don't know.  

> Does the predicate use sys_context() or does it
> use tables for its security check ? If the former,
> is the sys_context value perhaps not being set
> correctly. If the latter, are there any indications
> in trace files (set sql_trace true) that the referenced
> tables are definitely NOT being accessed when
> a 'predicated' query is executed ?

A combination. We use sys_context for the user name (working correctly) and then use tables to select the individual permissions for the user. I was unable to get the set sql_trace true command to work in sqlplus.

(I am a relative novice to Oracle. I'm more of an application developer as compared to an oracle DBA, but I'm learning.)

Thanks for responding, and for the help.

Zak

> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Screen saver or Life saver: http://www.ud.com
> Use spare CPU to assist in cancer research.
>
> Zachary Zebrowski wrote in message <3BB89071.5096BE7_at_mitre.org>...
> >Hi All.
> >We originally set up a database with working row level security. Over
> >the past four months, "something" has changed, and now the row level
> >predicate is not being applied. I say, not being applied because it is
> >still being generated correctly. Also, the predicate is enabled. It
> >simply is non obvious to me what has happened to make it not work. If
> >you could, send me any ideas as to what might have changed to make
> >Oracle 8i not work, reply to news group.
> >Thanks
> >Zak
Received on Mon Oct 01 2001 - 12:27:39 CDT