Hiya Buddies!!!
We would like to share a simple and easy topic as how to unlock EBS apps user in R12.1.3
There are two methods, we can do it either from
front-end or back-end.
Here, we would like to share the code which we have
done in Production and worked fine. So, there is no doubt.
But we need to change the user and password as per
our request username and password.
Here, for example in our case username is ora-data which status is as
LOCKED.
If you want to change it from back-end then you can
run the below command from apps user.
SQL> select name from v$database;
NAME
---------
ORA-DATA
SQL> show user
USER is "APPS"
SQL>
SQL>
DECLARE
status
BOOLEAN;
BEGIN
status :=
FND_USER_PKG.CHANGEPASSWORD(username => 'ora-data', newpassword =>
'welcome1234');
IF status
THEN
DBMS_OUTPUT.PUT_LINE('Password
changed and user unlocked');
commit;
ELSE
DBMS_OUTPUT.PUT_LINE('Error while setting password');
END IF;
END;
/
PL/SQL procedure successfully completed.
SQL>
This type of request is usually used to come from the either application team or developer team. So, this is a type of daily DBA task activities.
And this is very easy way to change because as we know that changing from front-end , it is like headache because front-end always takes time to load and sometimes java issue doesn't support etc...
This type of request is usually used to come from the either application team or developer team. So, this is a type of daily DBA task activities.
And this is very easy way to change because as we know that changing from front-end , it is like headache because front-end always takes time to load and sometimes java issue doesn't support etc...
Hope this may useful and helpful. For any concerns
please let us know either in comment box or Contact Us above.
Some more useful links:
No comments:
Post a Comment