操作方法
创建与管理用户 创建用户 create user mr identified by mrsoft default tablespace users temporary tablespace temp;
创建用户 配置磁盘限额 create user east identified by mrsoft default tablespace users temporary tablespace temp quota 10m on tbsp_1;
创建用户 配置在指定表空间不受限制 create user df identified by mrsoft default tablespace tbsp_1 temporary tablespace temp quota unlimited on tbsp_1;
用户权限管理 授权操作 为用户授予连接和开发权限 --创建用户dongfang create user dongfang identified by mrsoft default tablespace users quota 10m on users; --创建用户xifang create user xifang identified by mrsoft default tablespace users quota 10m on users; --授权 grant create session,create table to dongfang with admin option; connect dongfang/mrsoft; grant create session,create table to xifang; --连接到xifang connect xifang/mrsoft; create table tb_xifang ( id number, name varchar2(20) );