Session ID nonsense

From: AleX <korrozia_at_my-deja.com>
Date: Thu, 14 Oct 1999 23:22:53 GMT
Message-ID: <7u5ok1$eff$1@nnrp1.deja.com>

I have seen a very strange situation. I'm on 8.0.5.1 on Sequent. I have a trigger which extracts osuser name for each insert or update. The SQL looks like this:

select osuser
into v_osuser
from v$session
where audsid = USERENV('SESSIONID');

However, when a job runs (owned by an account different from the table/trigger owner), it runs a procedure which inserts a row into the table and it gets ora-1422 error. When I run the procedure from sqlplus I never get this error. So that means that the SNP process uses a different osuser name for the same session id??? So a session id can be shared for 2 different users? Any ideas?

                 Alex Shterenberg

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 18:22:53 CDT