Skip to Main Content
Forums

Java EE (Java Enterprise Edition) General Discussion

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

j2EE login

843830Sep 21 2006 — edited Sep 22 2006
Hi,
Sorry for the repost, I thought I'd reword my question and try my luck!

I have implemented a system to allow users to login to my j2EE system from any type of client application (including ones they have created themselves) but I'm not sure how to make sure that future commands are coming from the same person who previously logged in!

Does anybody have any ideas?

Comments

221158
Create a procedure on the remote database to alter the user password. Parameterise password and username and call it over a db link

Christopher Soza
Oracle BI DBA
Orix Consultancy Services Ltd
b: http://sozaman.blogspot.com
MichaelS
Answer
You can try something like
declare
 job binary_integer;
begin
 dbms_job.submit@dblink1(job,'begin execute immediate ''alter user xy identified by ..... ''; end;');
end;
Marked as Answer by 660270 · Sep 27 2020
660270
Thank you very much, this was exactly what I was after, you are a super star. Using the dbms_job.submit works a treat.
338570
I used this method. I don't have errors, but password is not changed.
What is my problem?
Mary
1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 20 2006
Added on Sep 21 2006
#enterprise-javabeans
3 comments
99 views