How to enable in APEX the Fine-grained access control feature
734444Feb 3 2010 — edited Feb 5 2010Hello there,
does anybody know how to do that?
Reading around it seems that that feature of being able to provide row access control is part only of the enterprise edition. However, it surely is not, because there is a tutorial on how to set up this in APEX. However, when I write this it comes up with the error above, that said feature is not enable. This is to mount the Virtual Private Database that allows you row access control.
I guess the line of code that would mean "private access is the one that says, policy_function => 'user only'
BEGIN
DBMS_RLS.add_policy
(object_schema => 'data_schema',
object_name => 'EMPLOYEES',
policy_name => 'EMP_SEL_POL',
function_schema => 'HR',
policy_function => 'USER_ONLY',
statement_types => 'SELECT');
END;
/
thank you very much
Edited by: Alvaroe on 03-Feb-2010 10:37