對這文章發表回應
發表限制: 非會員 可以發表
發表者： 冷日 發表時間： 2019/3/22 11:36:12
how to unlock user
I installed Oracle 11g R2 sucessfully. But not able to login as i found message user locked , kindly guide me how to unlock user.
1. Re: how to unlock user
Pobaly your user needs create session priviledge.
Log in as a SYSTEM and performs the grant below.
Regards,
Raul.
2. Re: how to unlock user
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.
Hope this will help you
原文出處：how to unlock user | Oracle Community
I installed Oracle 11g R2 sucessfully. But not able to login as i found message user locked , kindly guide me how to unlock user.
1. Re: how to unlock user
Pobaly your user needs create session priviledge.
Log in as a SYSTEM and performs the grant below.
grant create session to USER;Regards,
Raul.
2. Re: how to unlock user
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.
Hope this will help you
原文出處：how to unlock user | Oracle Community