表查询互相授权
--需要被查询的用户登录oracle(假如为mis) B为要查询misapp用户下的表的用户
--查询语句
select 'grant select on mis.'|| tname ||' to misapp;' from tab;
--授权
grant select on mis.DEPARTMENT to misapp;
grant select on mis.MENULIST to misapp;
grant select on mis.MIS_OPERATIONLOG to misapp;
grant select on mis.REL_SYS_ROLE_MENU to misapp;
grant select on mis.REL_SYS_SYS to misapp;
grant select on mis.REL_USER_DEP to misapp;
grant select on mis.REL_USER_ROLE to misapp;
grant select on mis.REL_USER_SYS_DEPT to misapp;
grant select on mis.ROLELIST to misapp;
grant select on mis.SYSLIST to misapp;
grant select on mis.SYSTEMLOG to misapp;
grant select on mis.SYS_MANAGER to misapp;
grant select on mis.USERLIST to misapp;
grant select on mis.USER_MENU_STAT to misapp;
----需要被查询的用户登录oracle(假如为misapp) B为要查询mis用户下的表的用户
--查询语句
select 'grant select on misapp.'|| tname ||' to mis;' from tab;
--授权
grant select on misapp.DEPARTMENT to mis;
grant select on misapp.MENULIST to mis;
grant select on misapp.MIS_OPERATIONLOG to mis;
grant select on misapp.REL_SYS_ROLE_MENU to mis;
grant select on misapp.REL_SYS_SYS to mis;
grant select on misapp.REL_USER_DEP to mis;
grant select on misapp.REL_USER_ROLE to mis;
grant select on misapp.REL_USER_SYS_DEPT to mis;
grant select on misapp.ROLELIST to mis;
grant select on misapp.SYSLIST to mis;
grant select on misapp.SYSTEMLOG to mis;
grant select on misapp.SYS_MANAGER to mis;
grant select on misapp.USERLIST to mis;
grant select on misapp.USER_MENU_STAT to mis;
grant select on misapp.YP_CHECK to mis;
grant select on misapp.YP_COMPANY to mis;
grant select on misapp.YP_DTL to mis;
grant select on misapp.YP_DTL_CHECK to mis;
grant select on misapp.YP_IN to mis;
grant select on misapp.YP_INFO to mis;
grant select on misapp.YP_INFO_CHECK to mis;
grant select on misapp.YP_LOG to mis;
grant select on misapp.YP_OUT to mis;
grant select on misapp.YP_USER to mis;