1. 查询当前用户角色,当前用户下的表权限以及所有用户表权限
desc user_role_privs;
select * from user_role_privs;
desc user_tab_privs;
select * from user_tab_privs;
desc all_tab_privs;
select * from all_tab_privs
where table_name = 'DF2_MONTHLY_ACTIVITY_083';
2.
1. 查询当前用户角色,当前用户下的表权限以及所有用户表权限
desc user_role_privs;
select * from user_role_privs;
desc user_tab_privs;
select * from user_tab_privs;
desc all_tab_privs;
select * from all_tab_privs
where table_name = 'DF2_MONTHLY_ACTIVITY_083';
2.
转载于:https://www.cnblogs.com/hello-yz/p/9602979.html