We can lock/unlock oracle database users using the following SQL statement:
SQL > alter user <username> account lock
Example:
1 2 3 4 5 6 7 8 9 | SQL> conn sys/orcl@to_primary as sysdbaConnected.SQL> ---To lock userSQL> alter user mereba account lock; User altered. --To unlock userSQL> alter user mereba account unlock; User altered. |
meda Changed status to publish 22/02/2022