Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Fine Grained Access Control
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