oracle数据库创建用户并授权

一、oracle创建用户语句，并赋予相关权限
create user usertest identified by pw123 DEFAULT TABLESPACE  testspace TEMPORARY TABLESPACE testspace _tmp;
--解锁用户
alter user usertest account unlock;
--给用户授权
grant connect, resource to usertest ;
--grant create session to usertest ;
--给用户授权
grant dba to usertest ;
--删除用户
drop user usertest cascade;