尚学堂Oracle笔记整理
1、解锁scott用户: alter user scott account unlock;I、在其他用户切换到sysdba用户 conn sys/root as sysdbaII、授权 grant create table,create view ,create session to scott2、以DBA身份登陆数据库 sqlplus sys/root as sysdba3、查看标的结构: