Where should I get "v$session.osuser "

Forum|Forum|3 years ago
January 16, 2023
1 reply
2186 views

Where should I get "v$session.osuser " And how to change the String limit of osuser name.

General Customization

Best answer by Cliff_17466

Please refer to below. OSUSER is the login user of Oracle client machine (e.g. the OS user who logged in Windchill server OS and start Windchill), and cannot change.

Cliff

C

Cliff_17466

7-Bedrock

execute sql via DBA user (not Windchill DB user)

select * from v$session;

Cliff

R

RS_10128209

Author

12-Amethyst

Thanks for replying

I'm not getting OSUSER as 'revati.sonkawde@pluraltechnology.com' anymore by executing

Select * from v$session;

I want to update this username i.e. 'revati.sonkawde@pluraltechnology.com' .

C

Cliff_17466

Answer

7-Bedrock

Please refer to below. OSUSER is the login user of Oracle client machine (e.g. the OS user who logged in Windchill server OS and start Windchill), and cannot change.

Cliff

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded