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>