Re: Restrict user access to table records by value

Hi,
you could use a view with an authorisation function: select *
from table
where function(user) = false/true.

The function result should depend on the user and the value of field A. Not to good for the performance however...

hth
Frans Hovenkamp

klwong_at_swire.com.au (KL Wong) wrote in message news:<5e65d905.0202120111.27d33a8e_at_posting.google.com>...
> We are using Oracle 8i with Crystal Decision product Seagate Info as
> reporting tools. Would like to check if there are any feature
> available in Oracle that can restrict user access to table records by
> value.
>
> For example:
>
> User A can access TABLE A record with field A = XYZ
> User B can access TABLE A record with field A = ABC
> User C can access TALBE A record with field A = any combination
>
> If oracle itself can do that by configuration, then we do not require
> to hardcode or build logic in Seagate Info reporting to perform all
> these restrictions checking.
>
> Appreciate any input.
>
> B.Rgds/KL
Received on Tue Feb 12 2002 - 15:57:37 CET