Re: Restrict user access to table records by value
From: Pablo Sanchez <pablo_at_dev.null>
Date: Tue, 12 Feb 2002 12:45:03 -0700
Message-ID: <4hea8.42$Hk.73873_at_news.uswest.net>
Date: Tue, 12 Feb 2002 12:45:03 -0700
Message-ID: <4hea8.42$Hk.73873_at_news.uswest.net>
Consider using a 'view' and granting access to a role which would have users in it.
-- Pablo Sanchez, High-Performance Database Engineering www.hpdbe.com Available for short-term and long-term contracts "KL Wong" <klwong_at_swire.com.au> wrote in message news:5e65d905.0202120111.27d33a8e_at_posting.google.com...Received on Tue Feb 12 2002 - 20:45:03 CET
> 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