對這文章發表回應
發表限制: 非會員 可以發表
發表者: 冷日 發表時間: 2019/3/22 11:38:30
How to unlock Oracle user account?
Here's how to lock or unlock Oracle database user accounts.
iguissouma commented on 26 Nov 2015
To unlock a user Run the following sql as administrator user like SYS or SYSTEM
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 :
change account password :
原文出處:How to unlock Oracle user account? · GitHub
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