Fine Grained Access Control

From: Hilary Band <hband_at_csc.com>
Date: 31 Jan 2003 08:03:47 -0800
Message-ID: <5b489863.0301310803.10e2c2ee@posting.google.com>

Version: 8.1.7.2.1 (Enterprise)
Platform: HP/UX

I am currently trying to set up FCAG on one of our databases and I have a question regarding adding a policy. I have a PL/SQL procedure which uses DBMS_RLS to add a policy. Do I have to run this procedure for every user who will be using the particular objects to which the policy applies?

At the moment I have a situation where I run the procedure as the schema owner and the policy is in place for that user but not for any other users who have access to the objects in the schema. However, all the context variables are being set correctly for the other users, it's simply that the policy isn't set for them.

Also, should access to DBMS_RLS be granted to PUBLIC or to each user of the database?

TIA H Received on Fri Jan 31 2003 - 10:03:47 CST