Search This Blog

Wednesday, July 27, 2022

Change a User's Password in Oracle, Unlock Oracle User

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

No comments:

Post a Comment

Read file content from an Oracle Directory in PL/SQL/ in IFS

Read single file DECLARE file_handle_ UTL_FILE.FILE_TYPE; directory_name_ CONSTANT all_directories.directory_name%TYPE := '...

Popular Posts