Re: Problem: Like-Statement and NULL-Fields

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

-- 
-------------------- http://NewsReader.Com/ --------------------
                    Usenet Newsgroup Service