FilesExpand file tree

master

/

add_fpol_9i_1.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

19 lines (15 loc) · 557 Bytes

master

/

add_fpol_9i_1.sql

Copy path

Top

File metadata and controls

• Code
• Blame

19 lines (15 loc) · 557 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

begin

dbms_fga.add_policy (

object_schema => 'HR',

object_name => 'EMP',

policy_name => 'EMP_SEL',

audit_column => 'SAL, COMM',

audit_condition => 'SAL >= 150000 OR EMPID = 100'

);

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/

*/