Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Lock and Unlock a User Account
How To Lock and Unlock a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: 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.
2007-05-01, 5292👍, 0💬
Popular Posts:
What would you use to compare two String variables - the operator == or the method equals()? You can...
Example of using Regular Expressions for syntax checking in JavaScript ... var re = new RegExp("^(&a...
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access ...
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...
What are the two kinds of comments in JSP and what's the difference between them? <%-- JSP Co...