oracle创建用户

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;