grant给表赋权限:
grant select/update on table to user;
grant 权限 on 表 to 用户。
2.grant 给存储过程赋权限:
grant execute on package/function/procedure to user;
grant execute on 过程、包、方法 to user
一次把权限给完(过程、包、方法):
grant execute any procedure to user;
给其创建触发器权限:
grant create trigger to username;