Fine Grained Access Control

From: ovind osengen <oeo_at_rocketmail.com>
Date: Thu, 19 Oct 2000 19:27:45 +0200
Message-ID: <8snaor$dmc$1@oslo-nntp.eunet.no>

I am designing a security mechanism with the fine grained access control. The filter should basically look like:

SELECT T.ID, T.CODE, T.NAME
FROM TABLE T
WHERE T.ID IN
( SELECT P.ID

    FROM PRIVILEGIES P
    WHERE P.READ_OWN = 'Y' )
AND
  CODE IN
( SELECT M.CODE

    FROM MAPPING M,
          PRIVILEGIES P
    WHERE M.CODE = P.CODE
      AND T.ID = P.ID ); However the security policy function only returns the predicate, but this cause T.ID in the 3rd select statement to be undefined. How can this be done better?

Best Regards
Ovind

oeo_at_rocketmail.com Received on Thu Oct 19 2000 - 12:27:45 CDT