生成库给代理用户授权
1:给表授权(增、删、改、查)
grant insert,delete,update,select on tab_user to e3web;
2:给多个表授权(查询user_objects表,拼接授权语句,把查询处理的结果一起执行)
select 'grant insert,delete,update,select on '||object_name ||' to e3web;' from user_objects t where t.object_name like 'TAB_%' AND object_type='TABLE'
3:给过程授权
grant execute on p_app_login to e3web;
4:给多个过程授权(查询user_objects表,拼接授权语句,把查询处理的结果一起执行)
select 'grant execute on '||object_name ||' to e3web;' from user_objects t where t.object_name like 'P_APP%' AND object_type='PROCEDURE'