DB研討會 : [轉貼]how to unlock user

• 發表新主題

發表者	討論內容
冷日 (冷日)	發表時間：2019/3/22 11:36
Webmaster 註冊日: 2008/2/19 來自: 發表數: 15771	[轉貼]how to unlock user 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. 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
回覆

平面展開

前一個主題 | 下一個主題 | | | |

討論串

•  » [轉貼]how to unlock user (冷日
  (冷日), 2019/3/22 11:36)
•      [轉貼]How to unlock Oracle user account? (冷日
  (冷日), 2019/3/22 11:38)
•        [轉貼]How to Unlock the Account in Oracle (冷日
  (冷日), 2019/3/22 11:55)
•          [轉貼]How to retrieve oracle passwords (冷日
  (冷日), 2019/3/22 11:57)