Database Security Products (MOSC)

MOSC Banner

insert during executing FGAC (dbms_rls package)

edited Aug 11, 2010 12:23AM in Database Security Products (MOSC) 4 commentsAnswered
Hello.
Please, look at my example where I use FGAC dbms_rls.add_policy

as user SCOTT:

CREATE TABLE test_table (
  a NUMBER(10,0) NULL
)
/

CREATE OR REPLACE function policy_test_table (object_schema IN VARCHAR2, object_name VARCHAR2) RETURN VARCHAR2 IS
BEGIN
 INSERT INTO test_table VALUES (99);
 RETURN '';                       
END;
/

and a test query to check this does work

SELECT * FROM test_table;

as user SYS:

BEGIN
 DBMS_RLS.ADD_POLICY (
 object_schema => 'scott',
 object_name => 'test_table',
 policy_name => 'test_table_policy',
 function_schema => 'scott',
 policy_function => 'policy_test_table',
 statement_types => 'SELECT',
 update_check => TRUE,
 enable => TRUE,
 static_policy => FALSE);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center