Skip to main content

Is there a way to capture the OS user that connects to the database via a JDBC or ODBC connection?

  • August 10, 2013
  • 2 replies
  • 16 views
Ryan_Weber
Is there way to capture the OS user that connects with a given database account via JDBC/ODBC in a similar manner as the SYS_CONTEXT('USERENV','OS_USER') reference used in Oracle?

    2 replies

    Naveen_Kumar_1
    • Naveen_Kumar_1
    • New Participant
    • October 3, 2014
    Is there any update on this?
    Naveen_Kumar_1
    • Naveen_Kumar_1
    • New Participant
    • October 6, 2014
    Here is the answer:

    select database_name, owner_name from databases;

    select current_database();

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement