DBA Utilities

I'll be adding any sort of DBA related code in this space for the time being. Some of it may end up being moved off into the Poor_Mans_Data_Vault though.

Triggers

• ddl_notifications_trigger - sends email notification on the AFTER DDL Database level event
• no_alter_in_dba_schema - in the event that you must grant developer certain system level privileges, this trigger will allow you to limit them from applying those changes in a DBA schema (thus potentially gaining access to higher level privileges)
• no_create_in_dba_schema - in the event that you must grant developer certain system level privileges, this trigger will allow you to limit them from applying those changes in a DBA schema (thus potentially gaining access to higher level privileges)
• no_drop_in_dba_schema - in the event that you must grant developer certain system level privileges, this trigger will allow you to limit them from applying those changes in a DBA schema (thus potentially gaining access to higher level privileges)
• secure_role_notifications - this trigger will send an alert whenever someone is granted a specified role. Good for monitoring when you have a set of roles with elevated privileges

Functions

• can_user_create_alter_drop