SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00904 insufficient privilege ..HELP

418679Nov 22 2005 — edited Nov 22 2005

Hi

I am using the following select statements (which selects from v$session) in a database trigger then it returns the following error..please help

PLS-00904: insufficient privilege to access object SYS.V_$SESSION

SELECT ltrim(rtrim(USERENV('SESSIONID')))
INTO asid
FROM DUAL;

SELECT TERMINAL,OSUSER
INTO TERM,OSUSR
FROM V$SESSION
WHERE ltrim(rtrim(to_char(AUDSID))) = to_char(asid);
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2005

Added on Nov 22 2005

3 comments

977 views