Audit

Real Interview questions for experienced DBAs – 1

Overview: Below are the questions asked to a candidate with 10 years of experience in Oracle DBA and postgres . There were 2 rounds.   Round 1 :  What are your day to day activities. And what is...

Useful oracle auditing related commands.

This articles contains useful command for both traditional and unified auditing . 1. How to enable auditing:(traditional) -- Auditing is disabled, when audit_trail is set to NONE SQL> show paramete...

ORA-09925: Unable to create audit trail file

PROBLEM: Users are getting below error, while trying to connect to the database. ERROR: ORA-09925: Unable to create audit trail file Linux-ia64 Error: 28: No space left on device Additional informatio...

ORA-28081: Insufficient privileges – the command references a redacted object

PROBLEM: While creating a table using CTAS, got below error: SQL> create table test as select * from DBACLASS.CREDIT_CARD_INFO; create table test as select * from DBACLASS.CREDIT_CARD_INFO * ERROR ...

Unified audit trail in Oracle 12c

OVERVIEW:                 With oracle 12c, unified auditing has been introduced. It consolidates all audit trails into a single audit trail table. It will capture audit records from below sour...

How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT

If your AUD$ table is in SYSTEM and SYTEM tablespace, Then it is advised to move the AUD$ to a dedicated tablespace. Use below steps to move AUD$. select owner,segment_name,segment_type,tablespace_nam...