倘若用scott用户连接oracle数据库时,提示
error: the account is locked
说明scott用户未被解禁。
解决办法:
以system用户登入,然后输入
SQL> alter user scott account unlock;
User altered
这样就可以以scott身份登录了,
SQL> conn scott/tiger
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as scott
如果要更改密码,(以system和scott身份登录都可以更改密码)
SQL> alter user scott identified by hunter;
User altered
SQL> conn scott/hunter
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as scott
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23739124/viewspace-665954/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23739124/viewspace-665954/