ORA-01017: invalid username/password; logon denied

zhangkun4884

于 2012-09-02 09:00:48 发布

阅读量272

点赞数

分类专栏： oracle 文章标签： table user

本文链接：https://blog.youkuaiyun.com/zhangkun4884/article/details/7933815

版权

oracle 专栏收录该内容

10 篇文章

订阅专栏

用dba登陆

SQL>conn sys/root as sysdba;

SQL> alter user SCOTT account unlock identified by tiger;

User altered.

SQL> select username,account_status from dba_users where username='SCOTT';



USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SCOTT    OPEN
SQL> conn scott/tiger
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT  TABLE
EMP   TABLE
BONUS TABLE
SALGRADE TABLE