Re: Q: VPD - how we can see full sql after the policy
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: Amihay.Gonen@xxxxxxxxxxx
- Date: Thu, 19 Feb 2009 10:20:02 +0100
Standard sql trace will not show what VPD added to your SQL queries.
You would need to set event 10730 to get a trace file showing what VPD
added.
On Thu, Feb 19, 2009 at 10:12 AM, Amihay Gonen <Amihay.Gonen@xxxxxxxxxxx>wrote:
> Hi all,
>
>
>
> One of our developers , ask me if there is someone to see the changed sql
> after VPD policy.
>
> She need that for debug propose. I guess using sql-trace can be an option
> , but this can be difficult since we've connection pooling + shared server.
>
>
>
>
>
> Any idea ?
>
>
>
--
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
(co)Author: "Applied Mathematics for Database Professionals"
Other related posts:
