sql-unlock-scott

给scott用户解锁,  以sysdba用户进入

alter user scott account unlock;

给scott用户设置密码

alter user scott identified by tiger;

 

 

创建用户wpms

created user wpms identified by wpms;

赋予权限

grant create session to wpms;

grant create table to wpms;

grant unlimited tablespace to wpms;