oracle用户管理与权限

1、创建与管理用户

创建用户

create user mr identified by mrsoft

default tablespace users

temporary tablespace temp;

2、创建用户

配置磁盘限额

create user east identified by mrsoft

default tablespace users

temporary tablespace temp

quota 10m on tbsp_1;

3、创建用户

配置在指定表空间不受限制

create user df identified by mrsoft

default tablespace tbsp_1

temporary tablespace temp

quota unlimited on tbsp_1;

4、用户权限管理

授权操作

为用户授予连接和开发权限

--创建用户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)

);