Warning: You are no longer connected to ORACLE.

最新推荐文章于 2024-09-03 11:16:57 发布

可心kokoro

最新推荐文章于 2024-09-03 11:16:57 发布

阅读量1.3w

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/u011388616/article/details/30027121

版权

Oracle 专栏收录该内容

3 篇文章

订阅专栏

Oracle安全性练习

【锁定adela账户】

SQL> alter user adela account lock;

User altered.
【锁定后连接】
SQL> conn adela/SAP;
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.

【以sysdba连接db，解锁】

SQL> conn / as sysdba;
Connected.
SQL> alter user adela account unlock;
User altered.
【再次以adela连db】
SQL> conn adela/SAP;
ERROR:
ORA-01045: user ADELA lacks CREATE SESSION privilege; logon denied
Warning: You are no longer connected to ORACLE.

【解决方法】

SQL> conn / as sysdba;
Connected.

SQL> grant create session to adela;

Grant succeeded.

SQL> conn adela/SAP;
Connected.
SQL>