what you had
in mind.
Jared
"Yechiel Adar" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/02/2002 06:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Changing SQL statemen
Thanks for the idea Tim but I am thinking about adding hints
to the sql or changing the FROM table.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 4:48 PM
> The Virtual Private Database (VPD) facility (
I'd believe it.
I have a classic in my seminar where
VPD/FGAC/RLS turned a simple single
table query into a 16-table join.
There is a vague directive from Oracle
nowadays that you should only be using
VPD to generate predicates involving
sys_context() calls, rather than attaching
subqueries. T
The Virtual Private Database (VPD) facility (a.k.a. "fine-grain" or
"row-level" security) can be used to alter SQL on the server, regardless of
origin. I implemented an access control list (ACL) feature for a system two
years ago, complete with recursion inside PL/SQL for navigating the
(implied)
Hello list
This time I need your help on how to implement a weird idea.
We have a third party application that fire wasteful SQL's to the database.
(Remember the discussion on using x$dual Vs dual some days ago?)
I am wondering: Is there a way to change the SQL that the user send?
In ADABAS on