Thank you for your response.
I agree with you, I do not see much value in it either.
I was asked to investigate it as some people use it in SQL Developer.
From: John Dorlon [mailto:email@example.com]
Sent: November 4, 2016 5:22 PM
Subject: RE: [Toad for Oracle - Discussion Forum] Oracle database authentication
RE: Oracle database authentication
Reply by John Dorlon
create user app_user identified by app_user;
create user end_user_ar identified by end_user_ar;
grant create session to app_user;
grant create session to end_user_ar;
alter user end_user_ar grant connect through app_user authentication required;
I’ve been working on this, and I’ve come across something that may help you. Unless I’m mistaken, both users need the CREATE SESSION privilege for this kind of proxy session. So can’t you just connect as END_USER_AR as a workaround? I mean, without using app_user at all?
I believe that I can have this kind of proxy session working soon, but I don’t see the value in it. I thought the point of proxy session was to be able to connect as the other user without having to know their password. What am I missing?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.