-
Notifications
You must be signed in to change notification settings - Fork 14
Expand file tree
/
Copy pathadd_rpol_relcols.sql
More file actions
31 lines (27 loc) · 893 Bytes
/
Copy pathadd_rpol_relcols.sql
File metadata and controls
31 lines (27 loc) · 893 Bytes
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
begin
-- drop the policy first.
dbms_rls.drop_policy (
object_schema => 'HR',
object_name => 'EMP',
policy_name => 'EMP_POLICY'
);
--
-- add the policy
--
dbms_rls.add_policy (
object_schema => 'HR',
object_name => 'EMP',
policy_name => 'EMP_POLICY',
function_schema => 'RLSOWNER',
policy_function => 'AUTHORIZED_EMPS',
statement_types => 'INSERT, UPDATE, DELETE, SELECT',
update_check => true,
sec_relevant_cols => 'SAL, COMM'
);
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/
*/