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;