OS_USER name is wrong after logon

[stef]

I have a strange behavior by logging on to PL/SQL developer.

If he locks on with Toolbar menu LogOnButton. Then he is locked on as administrator from the cluster machine. (OS_USER)
If he is using the Session-LogOn then you can see his name from his windows account.
Sometimes it's working perfect ;-?

Example:
OS_User normal Logon
PSmith

Wrong logon:
SERVER\administrator

Please help on this issue.
If you need more info let me now.

Using PL/SQL - 8.03.1510
Windows xp64

I needed the os_user for traceability!!

 

[Marco Kalter]

Where exactly do you see the OS_USER?

 

[stef]

I get this information from

select substr(nvl(sys_context('USERENV', 'OS_USER'),'unknown'),1,64) from dual;

 

[Marco Kalter]

I cannot reproduce this.

Is this reproducible for you?

 

[stef]

It is more complex as I thought.

We tried to do this on the machine(64-bit) an we can reproduce this functionality.

If he is starting up the PL/SQL Developer then he is connect with his normal name, but compiling will result in [machine-name]\Administrator

Then we connect by session; compiling the same procedure; The user is the local user.

The query result is in both cases the local user.

I'm using a trigger inside the sys-schema to create the records.

create or replace trigger DBA_DDLAuditTrigger
before create or alter or drop on arrow.schema

begin
insert into DBA_DDL_AUDIT values
(
nvl(ora_dict_obj_type,'unknown'),
nvl(ora_dict_obj_owner,'unknown'),
nvl(ora_dict_obj_name,'unknown'),
substr(nvl(ora_sysevent,'unknown'),1,18),
substr(nvl(sys_context('USERENV', 'OS_USER'),'unknown'),1,64),
substr(nvl(ora_login_user,'unknown'),1,30),
sysdate
);

end ADBA_DDLAuditTrigger;

My question:
If a user is logging on to PL/Sql is there a difference between change session inside the already started pl/sql program?

We only have this problem on one WS. This WS is a 64Bit operating system.

 

[Marco Kalter]

If a user is logging on to PL/Sql is there a difference between change session inside the already started pl/sql program?

No. Except that if you already have a connection, these sessions are first logged off.