1. To unlock an account:
ALTER USER account ACCOUNT UNLOCK;
2. To reset the password:
ALTER USER user_name IDENTIFIED BY new_password;
Useful Links:
> Using SQL*Plus to Unlock Accounts and Reset Passwords"All truths are easy to understand once they are discovered; the point is to discover them." - Galileo Galilei (rmaxonenote is a place for Oracle PL/SQL, C# and IFS related solutions, code snippets, and etc...)
1. To unlock an account:
ALTER USER account ACCOUNT UNLOCK;
2. To reset the password:
ALTER USER user_name IDENTIFIED BY new_password;
Useful Links:
> Using SQL*Plus to Unlock Accounts and Reset PasswordsRead single file DECLARE file_handle_ UTL_FILE.FILE_TYPE; directory_name_ CONSTANT all_directories.directory_name%TYPE := '...
No comments:
Post a Comment