Collections:
Lock and Unlock a User Account in Oracle
How To Lock and Unlock a User Account in Oracle?
✍: FYIcenter.com
If you want to lock a user account for a short period of time, and unlock it later, you can use the ALTER USER ... ACCOUNT command. The following sample script shows how to use this command:
>.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> ALTER USER dev ACCOUNT LOCK; User altered. SQL> disconnect SQL> CONNECT DEV/developer ORA-28000: the account is locked SQL> disconnect SQL> connect SYSTEM/fyicenter SQL> ALTER USER dev ACCOUNT UNLOCK; User altered. SQL> disconnect SQL> CONNECT DEV/developer Connected.
⇒ Privilege to Create Tables in Oracle
⇐ Revoke CREATE SESSION Privilege in Oracle
2019-06-29, 1634🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...