Authentication

From: Leon Rzhemovskiy <lrzhemov_at_home.com>
Date: Thu, 05 Oct 2000 04:50:28 GMT
Message-ID: <39DC0898.E8F4D891@home.com>

My question is related to ops$oracle account, Oracle enterprise manager and database auditing (aud$ table)

I have unauthorized connection to oracle 8.1.6 database on HP-UX from Windows NT workstation using ops$oracle account
(remote_os_authent=false). I am not able to reproduce this problem so
Oracle support is not able to help me. Any help greatly appreciated.

From listener.ora I have
14-AUG-2000 18:08:43 * (CONNECT_DATA=(SID=FSDEV)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.7\bin\jre.exe)(HOST=ERPTESTDB)(USER=SYSTEM))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.118)(PORT=2280)) * establish *
FSDEV * 0 in aud$ table I have:
USERID:OPS$ORACLE
SESSIONID 8419
ENTRYID 1
STATEMENT 1
ACTION_DATE 8/14/2000
TIME 18:08
USERHOST
TERMINAL ERPTESTDB
ACTION# 101
ACTION_NAME LOGOFF
RETURNCODE 0
OBJ$CREATOR
OBJ$NAME
AUTH$PRIVILEGES
AUTH$GRANTEE

NEW$OWNER
NEW$NAME
SES$ACTIONS
SES$TID
LOGOFF$LREAD 35798
LOGOFF$PREAD 190
LOGOFF$LWRITE 205

LOGOFF$DEAD 0
LOGOFF$TIME 14-Aug-00
COMMENT$TEXT Authenticated by: DATABASE; Client address:
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.118)(PORT=2280))
SPARE1 SYSTEM
SPARE2
OBJ$LABEL
SES$LABEL
PRIV$USED 5 ERPTESTDB(192.168.8.118) - win NT server FSDEV - oracle database on UNIX.
OPS$ORACLE - account authenticated by database

So, ops$oracle account, using oracle enterprize manager or other java utility get connected to oracle database on unix machine and has been authenticated by the database (not OS). It is not what I would expect from ops$oracle account.

Thanks
Leon Received on Wed Oct 04 2000 - 23:50:28 CDT