Oracle DBA Tutorial 9 - How to Lock and Unlock an user in Oracle database
[email protected] Chirag's Oracle DBA Tutorial https://www.chirags.in
*****************************************************************************************
How to lock and Unlock an user in Oracle database *
*****************************************************************************************
To temporarily deny access to the database for a particular user account, you can lock the user account.
Steps: ---
1. Login to your Oracle Database. (sqlplus / as sysdba) from command line.
2. run the below commands.
Get the list of username, account_status, created, lock_date and expiry_date.
SQL⇒ SELECT username, account_status, created, lock_date, expiry_date FROM dba_users;
lets consider the account of "chirag".
for more conditon.
(WHERE account_status != 'OPEN';)
Now lock the user account (Here i am locking account of chirag.)
SQL⇒ alter user chirag account lock;
User altered.
Again the get list of username, account_status, created, lock_date and expiry_date. And check chirag account is locked or not ??
SQL⇒ SELECT username, account_status, created, lock_date, expiry_date FROM dba_users;
CHIRAG LOCKED 15-AUG-19 03-SEP-19 29-FEB-20
now chirag account is unlock from below command
example : alter user username identified by password account unlock;
SQL⇒ alter user chirag identified by chirag account unlock;
User altered.
Again the check list of username, account_status, created, lock_date and expiry_date. And check chirag account is open or not ??
SQL⇒ SELECT username, account_status, created, lock_date, expiry_date FROM dba_users WHERE account_status != 'OPEN';
CHIRAG OPEN 15-AUG-19 01-MAR-20
Note : Flow the Process shown in video.
😉Subscribe and like for more videos:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment
Tutorial Link :
https://www.chirags.in/tutorials/orac...
Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be avilable in our website.
Link will be available in description.
#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags
Смотрите видео Oracle DBA Tutorial 9 - How to Lock and Unlock an user in Oracle database онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chirags Tutorial 05 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 256 раз и оно понравилось 4 людям.