HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

Oracle SQL Developer 4: how to tell under which user I connected

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlusertellunderconnectedhowwhichdeveloperoracle

Problem

I'm using Oracle SQL Developer 4 to connect to multiple databases at the same time, sometimes using different credentials that those saved in connection properties. So I have multiple tabs in main window labeled with DB names, but I'd like also have indication of under which account I'm connected (seems natural to have it in tab label/name).
Any option setting to achieve this? Probable I'm looking in wrong place or can do some query to check currently using credentials?

Solution

You could save multiple connections to the same db but with different credentials. Give them useful names like user@thisdb and you'll be able to view that in SQL Developer at a glance in the top right corner of the worksheet.

And my favorite part: if you need to run the same SQL as multiple users or in different environments or both, you'll find that the connection name in the top right corner of the worksheet is actually a dropdown list, so it can be changed on the fly.

Context

StackExchange Database Administrators Q#61317, answer score: 5

Revisions (0)

No revisions yet.