|
SQL>
SQL>
SQL> create table data_table
2 ( some_data varchar2(30),
3 OWNER varchar2(30) default USER
4 )
5 /
Table created.
SQL> begin
2 dbms_rls.add_policy
3 ( object_schema => 'userName',
4 object_name => 'data_table',
5 policy_name => 'MY_POLICY',
6 function_schema => 'TKYTE',
7 policy_function => 'security_policy_function',
8 statement_types => 'select, insert, update, delete' ,
9 update_check => TRUE,
10 enable => TRUE
11 );
12 end;
13 /
begin
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained access control
ORA-06512: at "SYS.DBMS_RLS", line 20
ORA-06512: at line 2
SQL>
SQL> drop table data_table;
Table dropped.
|