Let’s say that your Oracle apps password got locked and you need the help of your system administrator to reset the password for you, but unfortunately he is not reachable.
Luckily if you have toad access for that particular instance, you can use the below query to change the password.
declare
l_flag boolean;
begin
l_flag := fnd_user_pkg.CHANGEPASSWORD('username','password');
end;
Click commit button.
Ex:
declare
l_flag boolean;
begin
l_flag := fnd_user_pkg.CHANGEPASSWORD('orasupport','oracle1234');
end;
Click commit button.
Luckily if you have toad access for that particular instance, you can use the below query to change the password.
declare
l_flag boolean;
begin
l_flag := fnd_user_pkg.CHANGEPASSWORD('username','password');
end;
Click commit button.
Ex:
declare
l_flag boolean;
begin
l_flag := fnd_user_pkg.CHANGEPASSWORD('orasupport','oracle1234');
end;
Click commit button.
---X---
Thanks for sharing your thoughts. I really appreciate your efforts and I will be waiting for
ReplyDeleteyour further post thanks once again.
Here is my web site - password reset
Kudos for the comment. Will post more useful info's in the future...
DeleteHey would you mind stating which blog platform you're working
ReplyDeletewith? I'm looking to start my own blog in the near
future but I'm having a hard time selecting between BlogEngine/Wordpress/B2evolution and Drupal.
The reason I ask is because your design seems different then most blogs and I'm looking for something completely unique.
P.S Sorry for getting off-topic but I had
to ask!
Here is my web page: cheap brown prom dress with no straps
It's ok. I use blogger.com. It is more or less similar to wordpress but user friendly and provides us so many options for designing our own blog. I have used a basic simple model. Try yourself it is very easy...
DeleteHi there it's me, I am also visiting this site regularly, this site is truly pleasant and the people are truly sharing fastidious thoughts.
ReplyDeleteCheck out my web blog ... woodworking plans