删除用户及所有对象,创建用户

删除用户

 drop user XXXX cascade;

创建用户

CREATE USER xxxx IDENTIFIED BY xxxx
DEFAULT TABLESPACE mySpace;
 grant connect,resource,imp_full_database ,exp_full_database to xxxx;