Restrict user access to table records by value
From: KL Wong <klwong_at_swire.com.au>
Date: 12 Feb 2002 01:11:46 -0800
Message-ID: <5e65d905.0202120111.27d33a8e_at_posting.google.com>
Date: 12 Feb 2002 01:11:46 -0800
Message-ID: <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:
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
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