There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database .

What is DDL ??

DDL (Data Definition Language) is a language used by a database management system that allows users to define the database and specify data types, structures and constraints on the data. Examples DDL statements are: CREATE TABLE, CREATE INDEX, ALTER, and DROP.

Here we need to create a table where all ddl statements in database will be captured, so that we can identify the who has executed the DDL statement in the database.

So finally here we have deployed the mechanism to capture the ddl’s in the entire database.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Arun Gupta’s LinkedIn:   www.linkedin.com/in/agoradba/

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.