oracle logon trigger
Want to write oracle logon trigger, which will check record from below tables. if record not found then user session will not authorized.
Create table authorised_ips
(ip_address varchar2(20));
how to do this?
without using table logon trigger as below
CREATE OR REPLACE TRIGGER rds_logon_trigger
AFTER LOGON ON DATABASE
BEGIN
IF SYS_CONTEXT('USERENV','IP_ADDRESS') not in ('192.168.2.121','192.168.2.123','192.168.2.233') THEN
RAISE_APPLICATION_ERROR(-20003,'You are not allowed to connect to the database');
END IF;