error ora-06512 while login to database

[me_lucky]

Hi,

I have written a trigger as below:

CREATE OR REPLACE TRIGGER LOGONTRIG
AFTER LOGON ON DATABASE
DECLARE

v_temp NUMBER;
V_bypass_trg_flag VARCHAR2(1);
BEGIN
Begin
SELECT 1
INTO v_temp
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';

Exception
When NO_DATA_FOUND then
V_bypass_trg_flag := 'N';
END ;
DBMS_SESSION.SET_CONTEXT('TOPS_APP_CTX', 'TRG_BYPASS_USER',V_bypass_trg_flag);
END ;

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,
Lucky.

[Tim...]

Hi.

I wouldn't advise granting DBA to them. That kinda gives them the keys to the cookie jar.

Revoke DBA from the user and experiment to see what privileges are required to get it to work. I would start with execute on DBMS_SESSION and ALTER SESSION privileges.

Cheers

Tim...

[me_lucky]

Dear Team,

Thanks for the support.

I was able to resolve the issue, by handling exception.

Thanks,
Lucky.

[Tim...]

OK.

Cheers

Tim...