Q

Reading WSID from back-end

We're using the following string to connect to the Oracle DB Server through the OraOLEDB Driver. We want to read WSID from this string in the back-end session for the purpose of auditing using triggers. Is there any means of reading this information in the back-end?

We're using the following string to connect to the Oracle DB Server through the OraOLEDB Driver:
Provider=OraOLEDB.Oracle;Data
Source=MyOracleDB;User
Id=test;Password=test;WSID=test
We want to read WSID from this string in the back-end session for the purpose of auditing using triggers. So is there any means of reading this information (WSID) in the back-end? (WSID=Workstation ID.)
You may want to look at the connection data inside Oracle:
column username format a12 heading 'User Name'
column program format a25 heading 'Executing|Program'
column pid format 9999
column sid format 9999
column osuser heading Operating|system|User format a10
column terminal format a10
column g_date new_value f_date noprint
select to_char(sysdate,'ddmmyyyyhh24mi') g_date from dual;
set lines 130
break on username
compute count of pid on username
set pages 58
start title132 "Oracle Processes"
spool rep_out&dbcur_proc_&&f_date
select
        NVL(a.username,'Null') username,
        b.pid,
        a.sid,
        decode(a.terminal,'?','Detached',a.terminal) terminal,
        b.program,
        spid,
        a.osuser,
        a.serial#
 from
        v$session a,
        v$process b
where
        a.PADDR = b.ADDR
order by
        a.username,
        b.pid
/
spool off
clear breaks
clear columns



Operating
                                    Executing
system
User Name      PID   SID TERMINAL   Program                   SPID
User          SERIAL#
------------ ----- ----- ---------- ------------------------- ------------
---------- ----------
OEMMAN          14    15 MRALAPTOP2 ORACLE.EXE                2496
SYSTEM              7
                15    14 MRALAPTOP2 ORACLE.EXE                3336
SYSTEM              8
                16    16 MRALAPTOP2 ORACLE.EXE                3908
SYSTEM            174
                17    11 MRALAPTOP2 ORACLE.EXE                3732
SYSTEM             14
                18    12 MRALAPTOP2 ORACLE.EXE                132
SYSTEM             33
                19    18 MRALAPTOP2 ORACLE.EXE                300
SYSTEM              6
                20    19 MRALAPTOP2 ORACLE.EXE                604
SYSTEM              6
                21    20 MRALAPTOP2 ORACLE.EXE                976
SYSTEM             12
                22    21 MRALAPTOP2 ORACLE.EXE                4152
SYSTEM             13
************ -----
count            9
SYSTEM          23    22 MRALAPTOP2 ORACLE.EXE                2688
Mike?Ault        2851
************ -----
count            1
Null             2     1 MRALAPTOP2 ORACLE.EXE                2904
SYSTEM              1
                 3     2 MRALAPTOP2 ORACLE.EXE                2976
SYSTEM              3
                 4     3 MRALAPTOP2 ORACLE.EXE                2940
SYSTEM              1
                 5     4 MRALAPTOP2 ORACLE.EXE                2956
SYSTEM              1
                 6     5 MRALAPTOP2 ORACLE.EXE                2900
SYSTEM              1
                 7     6 MRALAPTOP2 ORACLE.EXE                2924
SYSTEM              1
                 8     7 MRALAPTOP2 ORACLE.EXE                2500
SYSTEM              1
                 9     8 MRALAPTOP2 ORACLE.EXE                2604
SYSTEM              1
                12     9 MRALAPTOP2 ORACLE.EXE                972
SYSTEM              1
                13    10 MRALAPTOP2 ORACLE.EXE                2608
SYSTEM              1
************ -----
count           10
This was last published in January 2006

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close