ctcgag_at_hotmail.com wrote:
> Karsten Farrell <kfarrell_at_medimpact.com> wrote:
>
>>Since you can't change the SQL directly, maybe you can do it "through
>>the backdoor". Take a look at Virtual Private Databases (used to be
>>called Fine-Grained Access Control, which earlier was called Row Level
>>Security - hence the package you use is DBMS_RLS). The documentation
>>didn't always keep up with these name changes, so it might be a little
>>confusing at times knowing what they're talking about.
>>
>>Basically, a VPD allows you to dynamically change the WHERE clause any
>>time anyone selects from the Users table. So you can add your NULL check
>>as a VPD feature.
>
>
> Does VPD allow you make the where clause less restrictive rather than more?
> I thought you could only (in effect) wrap the old where clause in
> parentheses and add 'AND new_expression' to the end.
>
> Xho
>
Yes, you are correct. You cannot change the part of the WHERE clause
that the application already uses.
Received on Thu Oct 24 2002 - 11:33:27 CDT
