oracle创建用户并受权SQL
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;