Oracle 新建用户赋权

grant create session to eosccb;//授予eosccb用户创建session的权限，即登陆权限
grant unlimited tablespace to eosccb;//授予eosccb用户使用表空间的权限
grant create table to eosccb;//授予创建表的权限
grante drop any table to eosccb;//授予删除表的权限
grant insert any table to eosccb;//插入表的权限
grant update any table to eosccb;//修改表的权限
grant create any index to eosccb;//创建索引权限
grant create view to eosccb;//创建视图权限

1）创建用户： create user wmlt identified by wmlt;

2）授予dba权限 grant connect,resource,dba to wmlt;


1、a用户下授权查询单个表给b用户
grant select on a.tablename to b;

2、授权a用户下授权更新单个表给b用户
grant update on a.tablename to b;

3、授权a用户下取消给b用户删除单个表的授权
revoke delete on a.tablename from b;

4、授权a用户下授权删除单个表给b用户
grant delete on a.tablename to b;

5、拥有dba权限的用户下授权创建dblink给b用户
grant create database link to b;