I have written a trigger as below:
CREATE OR REPLACE TRIGGER LOGONTRIG
AFTER LOGON ON DATABASE
FROM PARAMETER_TABLE A
WHERE A.PARAM_VAL = SYS_CONTEXT('USERENV', 'SESSION_USER')
AND A.PARAM_NM = 'TEST_USR' AND ROWNUM = 1;
V_bypass_trg_flag := 'Y';
When NO_DATA_FOUND then
V_bypass_trg_flag := 'N';
This trigger got successfully compiled. and when am trying to connect to the db with other user its giving me error "ora-06512 : at dbms_session".
When i grant dba privillage to that user am successfully able to login to db. Pl help me in resolving the issue.
Thanks in Advance,