After trigger using schema level?

Viewed 14
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;
0 Answers
Related