oracle创建用户并受权SQL

--创建用户

Create User Lotsnew

? Identified By "lotsnew"

? default tablespace LOTS --指定默认表空间

? profile DEFAULT

? ACCOUNT UNLOCK;

??

--给新建用户授DBA权限

Grant Dba To Lotsnew;

grant unlimited tablespace to lotsnew;