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

• 發表新主題

發表者	討論內容
冷日 (冷日)	發表時間：2019/3/22 11:55
Webmaster 註冊日: 2008/2/19 來自: 發表數: 15773	[轉貼]How to Unlock the Account in Oracle How to Unlock the Account in Oracle Steps 1 Find which accounts are locked with the following query. SQL > select username,account_status from dba_users where account_status like '%LOCK%'; USERNAME ACCOUNT_STATUS ------------------------------ ---------------- OUTLN EXPIRED & LOCKED MDSYS EXPIRED & LOCKED MDDATA EXPIRED & LOCKED 2 Unlock the user with the following command. SQL > alter user MDDATA account unlock; User altered. 原文出處：How to Unlock the Account in Oracle: 2 Steps (with Pictures)
回覆

平面展開

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

討論串

•    [轉貼]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)