Using "tracefile_identifier" Oracle will add that to the name of the user's trace filename so the file can easily be identified. For example if one needs to trace multiple users session who have different schema or OS user then using "tracefile_identifier" one can identify the trace file specific to a user. Example: The following trigger … Continue reading Example of using tracefile_identifier
Tag: logon
How to configure Windows to display a message when users log on?
How to turn off case sensitive in 11g
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean TRUE SQL> SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE; System altered.
Trigger to monitor successful logins in the database
By having a logon trigger in a database one can monitor or audit OS user, programs, DB users, time users logging into a database. It could also be used the change a behavior of a session by altering user's session's based on certain criteria. CREATE TABLE sys.logon_audit ( logon_time DATE, username VARCHAR2(30), -- DB user … Continue reading Trigger to monitor successful logins in the database
alexlima.com 