Oracle who is logged in

Would you consider submitting it to the Code Exchange? Ted, Thanks for the URL. Thanks, Ron. You can also get user by show user.

Adrian Cortinas Posted May 11, 0 Comments. Ya, show user is the correct command for knowing which user connected. It will give you an idea. Yes, it is the right command. Anonymous Posted May 9, 0 Comments. Jack D. Register or Login. Welcome back! Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta.

Now live: A fully responsive profile. Linked Related Any option setting to achieve this? Probable I'm looking in wrong place or can do some query to check currently using credentials?

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.

Without issueing a SQL command the only way would be to set the color highlighting for the connection manually. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Asked 1 year, 4 months ago. Active 4 months ago. Viewed 53 times. Vamsi Jayavarapu. Vamsi Jayavarapu Vamsi Jayavarapu 25 1 1 silver badge 7 7 bronze badges. Add a comment. Active Oldest Votes. By using this query we can get currently logged in user select user from dual;.