Re: FGAC Question

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Sep 2005 07:22:23 -0700
Message-ID: <1127485343.840922.262910@g44g2000cwa.googlegroups.com>

Ryan, Mu gut feeling is yes but I do not think anyone can really help you with just the information provided. As they say the devil is in the details and even though you state what you have to do there really isn't much detail about how.

For those not familiar with the acronyms used

FGAC is Fine Grained Access Control
OLS is Oracle Label Security which is not a commonly used feature

You might consider if you can create more efficient access to the public status and user privileges via traditional views and reference those views within your RLS (Row Level Security) package.

Also think about if you can set any global security tags via a database logon event trigger that would allow you to simplify the predicates being used.

HTH -- Mark D Powell -- Received on Fri Sep 23 2005 - 09:22:23 CDT