René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Client events [Oracle] | ||
Triggers can be created to be fired when a certain client event happens.
Available client events
A trigger can be created on the following client events in 10g.
before/after alter
For alter user events, the
ora_des_encrypted_password
event attribute functions can be used.
For alter table events, the
ora_is_alter_column and
ora_is_drop_column
event attribute functions can be used.
before/after dropbefore/after analyzebefore/after associate statistics
ora_dict_obj_name_list and
ora_dict_obj_owner_list are
event attribute functions that can be used for this event.
before/after auditbefore/after nouaditbefore/after commentbefore/after create
For the special case of a trigger on create table, the
ora_is_creating_nested_table event
attribute function can be used.
before/after ddlbefore/after grant
ora_grantee,
ora_privileges,
ora_with_grant_option are
event attribute functions that can be used for this event.
before logoff
A trigger for this event can also use the
ora_client_ip_address function.
after logoffbefore/after renamebefore/after revoke
A trigger for this event can also use the
ora_revokee function.
after suspend
A trigger for this event can also use the
ora_server_error,
ora_is_server_error and
space_error_info
function.
before/after truncateattribute functions
In triggers for client events, the following
event attribute functions can be used:
The following attribute functions can be used in all client events except before/after audit,
before logoff, after logon and after suspend:
Links
See also system events.
|