OraFAQ Forum: Security » Audit retention period

Home » RDBMS Server » Security » Audit retention period (Oracle,19.0.0.0.0,RHEL Server release 7.9 )

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

Audit retention period [message #689487]

Fri, 19 January 2024 01:57

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Hi,

Could you please let me know how to find the retention period of audit logs, time and who saves it.

Regards,
balaji

Report message to a moderator

Re: Audit retention period [message #689488 is a reply to message #689487]

Fri, 19 January 2024 02:29

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at DBMS_AUDIT_MGMT package.

Report message to a moderator

Re: Audit retention period [message #689489 is a reply to message #689488]

Fri, 19 January 2024 03:29

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Could you please explain in detail. Where would I get this package and what to check in that.

Report message to a moderator

Re: Audit retention period [message #689490 is a reply to message #689489]

Fri, 19 January 2024 03:33

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

https://docs.oracle.com/en/database/oracle/oracle-database/index.html

Report message to a moderator

Re: Audit retention period [message #689491 is a reply to message #689490]

Fri, 19 January 2024 03:51

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

I have attached the code of the package. Could you please suggest me what to check in the pacakge.

Attachment: Package.txt
(Size: 62.61KB, Downloaded 468 times)

Report message to a moderator

Re: Audit retention period [message #689492 is a reply to message #689491]

Fri, 19 January 2024 04:21

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Nothing in this file just what is in the documentation.

Report message to a moderator

Re: Audit retention period [message #689493 is a reply to message #689492]

Fri, 19 January 2024 04:28

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Are you blind? The file contains the code of the package and you are saying nothing in the file.

Report message to a moderator

Re: Audit retention period [message #689494 is a reply to message #689493]

Fri, 19 January 2024 05:10

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Hum! Of course this says all:

DBMS_METADATA.GET_DDL('PACKAGE','DBMS_AUDIT_MGMT','AUDSYS')
--------------------------------------------------------------------------------
N9yTWUD8+J1KW4xLsqCnGpPVj1yU18mVx5O9OR9keLfXzatcHux4qR0w9GfVcvXJ1K2fZ7py
Isg9kuNxD17qW5t4QRC1sOi5hu7vZ9l/O+Ah9XBNytm8S1STSBj045bB3HcpkL+E5fPIG+Js
FBzQobsITevNX9GfpSLLkpBvp5q1NY6ZzmFAAZgDx4lplocdVPonKrvnwWI/OHCDQ2cCkRlm
oQ6KUVWomcXtSmdkn0lmVRhwpnaC1y0Hvm1Juqj/f/Lb5U4icrNaQXoLxGv1djeCB6d5Rvk5
9Vr8irctiephKWHhQhKE3+u9nYS2/EixkDYM7wbberlAaqQ86Wpp2D72nP70glOUV9vpccAB
Bg/iQpLO3V84iOVdhyGA7HEKixBfAR9xu7kzHlx0fwXKzwwbc6HRrwEZTGQVG9Og9BppmzUT
dBPv0O/XWBS2fhM85t7RIf+G2B0x/qK8jO9CYbRZ6p0ui5ooQ4C/FiT6gpOM0ddVIWNDs6hS
Eg3IJJsxcwB51PyPKEIUjAkkAaSlqU/MC/h85IGlfnwcn5bL8VsHXGJjQJ5ebITsQ8gL6eVg
av8IMJFREjIEQQtECV+TgVlGMetlRbBPjc9PMUI+b891wuVAtAnh8VK0IExQEFz/ZrULPD85
6B7soHQaBwj/EM4Ak3n3bw7DzTjQgVrmmnIaxhIbAH952ehmLxupgCoyRhjZ8Dxdz7qlJtLy
DUbEXkUBIXEdnbp+ikDtk9cRnpInxB6b9JcJWnvMUB5iZc69yki0m4VubZaI1jhxubncmhcM

Report message to a moderator