oracle用户和权限管理
-- 创建基础用户
obclient> create user csdc identified by csdc;
-- 创建其他用户
obclient> create user csdc_u1 identified by csdc;
Query OK, 0 rows affected (0.02 sec)
-- 给基础用户赋权
obclient> grant dba to csdc;
-- 创建一个表
obclient> create table t1(id int);
-- 给其他用户赋权
obclient> grant create session to csdc_u1;
obclient> grant insert,update,select,delete on csdc.t1 to csdc_u1;
-- 尝试再本用户下创建表（失败）
obclient> create table t1(id int);
ORA-01031: insufficient privileges
-- 对csdc用户表进行基本操作
obclient> select * from csdc.t1;
Empty set (0.01 sec)
obclient> insert into csdc.t1 values (1);
Query OK, 1 row affected (0.01 sec)
obclient> delete from csdc.t1;
Query OK, 1 row affected (0.01 sec)
-- 使用角色进行操作
obclient> create role r_csdc;
obclient> grant create session,select any table, insert any table, update any table, delete any table,select any dictionary, create any procedure,execute any procedure,execute any type, show process,alter system,alter session to r_csdc;
obclient> create user csdc_u2 identified by csdc;
obclient> grant r_csdc to csdc_u2;
obclient> alter user csdc_u2 default role r_csdc;
