oracle沒(méi)有scott用戶 怎么給scott用戶解鎖?
怎么給scott用戶解鎖?打開(kāi)sqlplus:sqlplus/nolog進(jìn)入系統(tǒng)管理:conn system/unlock Scott with your password:alter user Sc
怎么給scott用戶解鎖?
打開(kāi)sqlplus:sqlplus/nolog進(jìn)入系統(tǒng)管理:conn system/unlock Scott with your password:alter user Scott account unlocked
Scott已鎖定,系統(tǒng)用戶密碼錯(cuò)誤。您可以使用sys user登錄并執(zhí)行SQL alter user Scott account unlocked user system,由管理員標(biāo)識(shí)
1。首先以DBA身份登錄Oracle10g。2修改socct帳戶權(quán)限,更改用戶scottaccountunlock。三。修改HR帳戶權(quán)限,更改用戶hraccountunlock。提交操作之后,繼續(xù):alter user hridentified by HR。4檢查狀態(tài),您會(huì)發(fā)現(xiàn)它已被解鎖。