oracle--对象权限

sys用户查询ww用户创建的表（已经commited）

select * from ww.wwTable;

普通用户lisi查询ww用户的表

grant select on wwTable to lisi;

select * from ww.wwTable;

对象授权操作

grant insert on wwTable to lisi;

grant all on wwTable to lisi;

撤销授权操作

revoke all  on wwTable from wwTable;

将表中某些列权限授予用户（只有更新和插入）

grant update(name) on wwTable to lisi;

grant insert(id) on wwTable to lisi;

测试： update ww.wwTable set name = 'sss' where id = 5;

查询列权限

select 8 from user_con_privs;