- Original Message -
> Policy function:
> DPA42HP92.DP_PREDICATE_FUNCTION_PKG.DP_PREDICATE_FUNCTION
> RLS view :
> SELECT "CURRENCY","CURRENCY_CODE","CURRENCY_DESC","CURRENCY_KEY" FROM
> "DPA42HP9
> 2"."DPR70_CURRENCY_D" "DPR70_CURRENCY_D" WHERE (CURRENCY_CODE in (select
> value_
> v
>
Sent: Thursday, August 21, 2003 1:49 AM
>
>
> > so in 9i dbms_rls increases the soft parses?
> > >
> > > From: Connor McDonald <[EMAIL PROTECTED]>
> > > Date: 2003/08/20 Wed AM 11:21:59 EDT
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
Hi Nuno
> I don't think this is the issue at all. The SQL in the function
> that generates the predicate WILL use bind variables and that
> is perfectly expected. That's why you don't see an increase in parses
> on the SQL INSIDE the function.
>
That is correct. I should have posted the predic
gt; >
> > From: Connor McDonald <[EMAIL PROTECTED]>
> > Date: 2003/08/20 Wed AM 11:21:59 EDT
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: Re: Row level security and latch waits
> >
> > My understanding was that
- Original Message -
>
> lets execute another query
> SQL> select count(*) from dpr70_gl_acct_balance_f;
>
> COUNT(*)
> --
> 2974
>
>
> from v$SQL
>
> SQL_TEXT
>
> PARSE_CALLS EXECUTIONS
Title: RE: Row level security and latch waits
Sorry Jack,
I didn't preserve the title ... it was copied from an internal email. Also the _ parameters are never documented in official ora docs, Metalink is good for that.
Raj
-Original Message-
From: [EMAIL PROTECTED]
[m
Hi,
With the way we have implemented FGAC, we do not have any parses
occurring with application context.
The application context does act like bind variables and I will try to
illustrate that with an example.
We set the context of the users logging in to a particular group/role
which gets executed
[EMAIL PROTECTED]>
Subject: RE: Row level
security and latch waits
Sent by:
Title: RE: Row level security and latch waits
Jack,
This is from TFM ...
Starting from 9i, queries against Fine Grained Access enabled objects always execute the policy function to make sure most up to date predicate is used for each policy. For example, in case of the time based policy
some other people were saying if you use it with a 'context' it binds it.
is that accurate?
>
> From: [EMAIL PROTECTED]
> Date: 2003/08/20 Wed PM 04:09:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Row level security and la
uk> cc:
Sent by: Subject: Re: Re: Row level security
and latch waits
so in 9i dbms_rls increases the soft parses?
>
> From: Connor McDonald <[EMAIL PROTECTED]>
> Date: 2003/08/20 Wed AM 11:21:59 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Re: Row level security and latch waits
>
> My underst
, RajendraSent: Tuesday, August 19, 2003 11:49
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Row level security and latch waits
sorry this is 9202 and little less than 100
users.
Raj
My understanding was that the rls predicate was added
at parse time (hence the importance of the contexts
and avoiding things like 'sysdate')
But also if I remember correctly, this behaviour was
changed in v9 to process the security function with
each execution (and hence probably increase the am
- Original Message -
> - Use context values within predicates, as bind variables NOTE THIS
> LINE.>
None of that implies it's not appending a where clause like it
was explained.
It uses the context values (if that's the case) in a function
which then returns a string. Tha
Hi Raj,
Vadim is right and if RLS is implemented without application context then
there would be hard parses especially if there are literals in the policy
function . We have a client warehouse with about 500 users and 300 tables
and FGAC has been working very well and we do not see latch waits.
T
pients of list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: Re: Row level security
and
To: Multiple recipients
of list ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: Re: Row level
security and latch waits
.c
>
> >To: Multiple recipients of list
> ORACLE-L <[EMAIL PROTECTED]>
> Sent
[EMAIL PROTECTED]Sub
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Row level security and
latch waits
[EMAIL PROTECTED]
> Date: 2003/08/19 Tue PM 02:14:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: Row level security and latch waits
>
>
> RLS doesn't use bind variables? How then does Oracle treat the Application
> Context variab
dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Stephane Paquette
[mailto:[EMAIL PROTECTED]Sent: Tuesday, August 19,
2003 11:40 AMTo: Multiple recipients
Title: RE: Row level security and latch waits
This is interesting do you know where it is documented quickly? I'll do a rtfm/stfw in the mean time.
Thanks
Raj
Rajendra dot Jamadagni at nospamespn do
Title: RE: Row level security and latch waits
Yup.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is
: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Stephane Paquette
[mailto:[EMAIL PROTECTED]Sent: Tuesday, August 19,
2003 11:40 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Row level security and latch
waits
I've
develop
row level security doesnt use bind variables.
dont know if there is a way to get it to use them. thats probably your problem.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/08/19 Tue AM 11:19:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Row
Title: Row level security and latch waits
I've
developped 3 functions for fined-grain access control and the users have tested
them.
There
are only 3-4 users in the acceptance env. and I did not noticed
anything.
What
version are you running and how many users ?
We're
on 8172
Someday
Raj - In this case, RLS would be Row Level Security?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 19, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
hi all,
in the latest code release, a group implement
29 matches
Mail list logo