|
-
Hi,
Connect to the database with the user who is having DBA roles and change the password of your user in off peak hours(when user is not there). Then perform your activity and again set the original password by its value on the database.
e.g.
conn system/manager
sql>select username,password from dba_users where username='SCOTT';
USERNAME PASSWORD
------------------------------ ------------------------------
SCOTT 7304D3DD7C141581
SQL> alter user scott identified by dhaval;
User altered.
----------- Perform your activities -----------------------
SQL> alter user sdasari identified by values '7304D3DD7C141581';
User altered.
I hope this will solve your problem.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|