Hello:

You Can implement the Fine-Grained Access Control
and Application Context, in this way you can assign a
security function to the table which generates this
condition .After that in any case Oracle manipulates
this table will add a condition in the where caluse .
Read Oracle 8i for more information.

Good Luck

--- Ben Jenkins <[Email Address Removed] wrote:
> We are testing Cognos Query with Oracle 8.1.6. We
> would like to enforce row level security based upon
> Oracle user id's. (where client='ABC Company')
>
> Does anyone have suggestions for implementation.
> (Stored proc, VDB, etc.)
>
> Thanks, Ben
>
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
Oracle LazyDBA home page