Technical Notes
We're all on the same page!
Showing posts with label
sys_context
.
Show all posts
Showing posts with label
sys_context
.
Show all posts
Monday, 7 August 2017
e.g. simple DDL audit trigger
›
e.g. DDL audit trigger CREATE TABLE SYSTEM.audit_ddl_history ( osuser varchar2(50), session_user varchar2(50), host varchar2(50), ter...
Monday, 17 July 2017
SYS_CONTEXT function parameters and examples
›
Active parameters ACTION, AUDITED_CURSORID, AUTHENTICATED_IDENTITY, AUTHENTICATION_DATA, AUTHENTICATION_METHOD, BG_JOB_ID, CLIENT_IDENTIFIE...
Tuesday, 21 March 2017
How to manage logon mechanism with trigger ?
›
CREATE OR REPLACE TRIGGER SYS .DENY_LOGIN AFTER LOGON ON DATABASE BEGIN IF TO_CHAR (SYSDATE, 'hh24') BETW...
›
Home
View web version