OCA: Oracle Database 11g Administrator Certified Associate- P19

Tham khảo tài liệu 'oca: oracle database 11g administrator certified associate- p19', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Identifying PL SQL Objects 731 No grant to PUBLIC allowed for DICTIONARY_OBJ_OWNER . DICTIONARY_OBJ_NAME END IF END LOOP END In the preceding example the DDL event is a GRANT statement issued by user engineering. The code examines the grantee list and if it finds the special user role PUBLIC an exception is raised causing the grant to fail. Table shows the DDL trigger events. TABLE DDL Trigger Events Event When It Fires BEFORE AFTER ALTER When an ALTER statement changes a database object BEFORE AFTER ANALYZE When the database gathers or deletes statistics or validates the structure of an object BEFORE AFTER ASSOCIATE STATISTICS When the database associates a statistic with a database object with an ASSOCIATE STATISTICS statement BEFORE AFTER AUDIT When the database records an audit action except FGA BEFORE AFTER COMMENT When a comment on a table or column is modified BEFORE AFTER CREATE When the database object is created BEFORE AFTER DDL In conjunction with any of the following ALTER ANALYZE ASSOCIATE STATISTICS AUDIT COMMENT CREATE DISASSOCIATE STATISTICS DROP GRANT NOAUDIT RENAME REVOKE or TRUNCATE BEFORE AFTER DISASSOCIATE STATISTICS When a database disassociates a statistic type from a database object with a DISASSOCIATE STATISTICS statement BEFORE AFTER DROP When a DROP statement removes an object from the database BEFORE AFTER GRANT When a GRANT statement assigns a privilege BEFORE AFTER NOAUDIT When a NOAUDIT statement changes database auditing BEFORE AFTER RENAME When a RENAME statement changes an object name BEFORE AFTER REVOKE When a REVOKE statement rescinds a privilege BEFORE AFTER TRUNCATE When a TRUNCATE statement purges a table 732 Chapter 13 Managing Data and Undo Database Trigger Events Database event triggers fire when the specified database-level event occurs. Most of these triggers are available only before or after the database event but not both. The following example creates an after-server error trigger that sends an email .