oracle用户管理与权限

1、创建与管理用户创建用户create user mr identified by mrsoftdefault tablespace userstemporary tablespace temp;

2、创建用户配置磁盘限额create user east identified by mrsoftdefault tablespace userstemporary tablespace tempquota 10m on tbsp_1;

3、创建用户配置在指定表空间不受限制create user df identified by mrsoftdefault tablespace tbsp_1temporary tablespace tempquota unlimited on tbsp_1;

4、用户权限管理授权操作为用户授予连接和开发权限--创建用户dongfangcreate user dongfang identified by mrsoftdefault tablespace usersquota 10m on users;--创建用户xifangcreate user xifang identified by mrsoftdefault tablespace usersquota 10m on users;--授权grant create session,create table to dongfang with admin option;connect dongfang/mrsoft;grant create session,create table to xifang;--连接到xifangconnect xifang/mrsoft;create table tb_xifang( id number, name varchar2(20));