 |
|
茫茫網海中的冷日
發生過的事，不可能遺忘，只是想不起來而已！ |
|
|
恭喜您是本站第 1729866
位訪客!
登入 | 註冊
|
|
|
|
| 發表者 |
討論內容 |
冷日
(冷日) |
發表時間：2019/3/22 11:38 |
- Webmaster
- 註冊日: 2008/2/19
- 來自:
- 發表數: 15773
|
- [轉貼]How to unlock Oracle user account?
- How to unlock Oracle user account?
Here's how to lock or unlock Oracle database user accounts.
SQL> ALTER USER username ACCOUNT LOCK;
SQL> ALTER USER username ACCOUNT UNLOCK;
iguissouma commented on 26 Nov 2015
To unlock a user Run the following sql as administrator user like SYS or SYSTEM
ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;
here password is your passord which you want to use for your account remember this password for further use.
mohamad7788 commented on 12 Oct 2018 •
Thanks for sharing such command .
in this form , i would like to share a command to create Oracle account & change password
create account :
CREATE USER <account-name>IDENTIFIED BY <account-password> password expire DEFAULT TABLESPACE <table-space name> TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON <table-space name> PROFILE PERSONAL;
change account password :
alter user <account-name> identified by "<accountpassword>"
原文出處：How to unlock Oracle user account? · GitHub
|
|
|
|
|
討論串
|
[轉貼]how to unlock user (冷日