Home » RDBMS Server » Server Administration » Create Audit Policy on Package (Unified Auditing) (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.17.0.0.0)
Create Audit Policy on Package (Unified Auditing) [message #687512] Thu, 23 March 2023 10:19 Go to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
I can't seems to figure out how to create a policy to audit whenever the DBMS_FGA package is executed.

SQL> create audit policy execute_dbms_fga_add_policy actions execute on dbms_fga;
create audit policy execute_dbms_fga_add_policy actions execute on dbms_fga
                                                                   *
ERROR at line 1:
ORA-46356: missing or invalid action audit option.

Please advise. Thank you.
Re: Create Audit Policy on Package (Unified Auditing) [message #687513 is a reply to message #687512] Thu, 23 March 2023 10:28 Go to previous messageGo to next message
John Watson
Messages: 8916
Registered: January 2010
Location: Global Village
Senior Member
Works for me Smile
C:\Users\john>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 23 15:27:18 2023
Version 19.17.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

orclz> create audit policy execute_dbms_fga_add_policy actions execute on dbms_fga;

Audit policy created.

orclz>
Re: Create Audit Policy on Package (Unified Auditing) [message #687514 is a reply to message #687513] Thu, 23 March 2023 11:30 Go to previous message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
Thanks John that gives me idea that since I don't have a sys I can just qualify it with a sys.

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 23 12:28:45 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Enter password:
Last Successful login time: Thu Mar 23 2023 11:48:51 -04:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> create audit policy execute_dbms_fga_add_policy actions execute on sys.dbms_fga;

Audit policy created.

SQL>
Previous Topic: Oracle Tablespace Datafile Who Created
Next Topic: PROBLEAM OPEN REDOLOG FILE
Goto Forum:
  


Current Time: Thu Feb 29 13:25:20 CST 2024