Re: QUESTION: raise_application_error results in ORA-00604...?

From: BD <bobby_dread_at_hotmail.com>
Date: 25 May 2006 11:46:26 -0700
Message-ID: <1148582785.963808.229930@j33g2000cwa.googlegroups.com>

>5 Currently you don't allow sys to connect. That is going to be a problem.
Sys is able to connect (I just tried). The code is intended to only prevent the BROWSE_ID from logging on under the specific circumstances. The code grabs USER from DUAL. In the case of sys, USER from DUAL is 'SYS', not BROWSE_ID.

>2 Many of your selects from v$session can and should be replaced by calling the sys_context function
An earlier iteration of this trigger did use sys_context, but a co-worker recommended v$session. Can you give me a sense as to why sys_context is better than v$session?

>3 audsid is always 0 for user SYS and any user with SYSDBA. Your code is going to fail, as all SYS users have the same audsid, 0
I'll have to look closer at that - I'm not yet quite sure what you're telling me, but I'll look into it.

Thanks!! Received on Thu May 25 2006 - 13:46:26 CDT