日期:2014-05-16  浏览次数:20312 次

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;