By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

RDS Database Changes Log

0

I have a RDS Oracle database. I want to get the audit logs for any DB activities. I was able to get ModifyDBInstance entries in the CloudTrail. How do I view any DML/DDL activities? I guess the issue is how to search. I don't want to enable any query tools.

Topics
Migration & ModernizationAnalyticsDatabaseManagement & Governance
Tags
Amazon Relational Database ServiceAWS ConfigAWS CloudTrail
Language
English
Trichy18
asked 16 days ago109 views
1 Answer
1

Hello.

DML/DDL activity is logged in the database and cannot be viewed with CloudTrail.
Therefore, I think it would be a good idea to check the audit log etc. from the RDS log.
RDS logs can also be output to CloudWatch Logs.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.Oracle.html#USER_LogAccess.Oracle.PublishtoCloudWatchLogs

profile picture
EXPERT
Riku_Kobayashi
answered 16 days ago
profile picture
EXPERT
Osvaldo Marte
reviewed 16 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content