//删除用户对象
DROP USER scott CASCADE
//新建用户对象
create user scott identified by qwaszx —default tablespace test_tablespace;
—alter user scott account unlock identified by qwaszx;
//给新用户对象赋予权限
grant connect,resource,dba to scott;
//删除用户对象
DROP USER scott CASCADE
//新建用户对象
create user scott identified by qwaszx —default tablespace test_tablespace;
—alter user scott account unlock identified by qwaszx;
//给新用户对象赋予权限
grant connect,resource,dba to scott;