oracle里创建用户及分配权限的常用命令:
create user ylxc
identified by "ylxc"
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
grant connect to ylxc;
grant dba to ylxc;
grant resource to ylxc;
grant unlimited tablespace to ylxc;
转载于:https://www.cnblogs.com/harbin1900/archive/2012/01/05/8480980.html