-
Notifications
You must be signed in to change notification settings - Fork 14
Expand file tree
/
Copy pathadd_rpol_static.sql
More file actions
36 lines (33 loc) · 1.28 KB
/
Copy pathadd_rpol_static.sql
File metadata and controls
36 lines (33 loc) · 1.28 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
begin
dbms_rls.drop_policy (
object_schema => 'HR',
object_name => 'DEPT',
policy_name => 'EMP_DEPT_POLICY'
);
dbms_rls.add_policy (
object_schema => 'HR',
object_name => 'DEPT',
policy_name => 'EMP_DEPT_POLICY',
function_schema => 'RLSOWNER',
policy_function => 'AUTHORIZED_EMPS',
statement_types => 'SELECT, INSERT, UPDATE, DELETE',
update_check => true,
policy_type => dbms_rls.shared_static
);
dbms_rls.add_policy (
object_schema => 'HR',
object_name => 'EMP',
policy_name => 'EMP_DEPT_POLICY',
function_schema => 'RLSOWNER',
policy_function => 'AUTHORIZED_EMPS',
statement_types => 'SELECT, INSERT, UPDATE, DELETE',
update_check => true,
policy_type => dbms_rls.shared_static
);
end;
/*======================================================================
| Supplement to the fifth edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2009 O'Reilly Media, Inc.
| To submit corrections or find more code samples visit
| http://oreilly.com/catalog/9780596514464/
*/