1.授权
grant **权限on object to user
**权限 :
connect,select:查询 insert:插入 update:更新 delete:删除 all:所有
object:
table:表
view:视图
sequence:序列
index:索引
---------------------
例子:
grant select on tablename to user
grant connect to user
2,收回权限
revoke:
revoke **权限 from user
l例子:
revoke connect from user;
revoke select/insert/delete on 表名 from user