OraFAQ Forum: Server Administration » Create Audit Policy on Package (Unified Auditing)

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create Audit Policy on Package (Unified Auditing) [message #687512]

Thu, 23 March 2023 10:19

wtolentino
Messages: 422
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.

Report message to a moderator

Re: Create Audit Policy on Package (Unified Auditing) [message #687513 is a reply to message #687512]

Thu, 23 March 2023 10:28

John Watson
Messages: 8964
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>

Report message to a moderator

Re: Create Audit Policy on Package (Unified Auditing) [message #687514 is a reply to message #687513]

Thu, 23 March 2023 11:30

wtolentino
Messages: 422
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>

Report message to a moderator

Previous Topic:	Oracle Tablespace Datafile Who Created
Next Topic:	PROBLEAM OPEN REDOLOG FILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 19:03:29 CST 2025