Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE: select current (connection/session) user name?

416044Jan 9 2004 — edited Jan 9 2004

i need to send a SELECT statement via JDBC that returns the user name (or user id) of the current connection/session. because i didn't create the connection that i use, so i need to query the ORACLE database to get the current user info. where can i get this info from?

i can perform a

select * from v$session

but that just gives me all users. how can i get the current connection/session user?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2004

Added on Jan 9 2004

#java-database-connectivity-jdbc

3 comments

712 views