CREATE OR REPLACE TRIGGER testing1
AFTER
PM
LOGON
ON testing.SCHEMA
BEGIN
IF (UPPER(sys_context ('userenv','DB_NAME')) RRTTPMS1) THEN
raise application_error(-20001, 'Connection not authorised for this database');
END IF; EXCEPTION
WHEN OTHERS THEN
RAISE
END;