查看用户拥有的角色: select * from dba_role_privs where grantee='USERNAME'; 查看用户拥有的系统权限: select * from DBA_SYS_PRIVS where grantee='USERNAME'; 查看用户拥有的表权限: select * from DBA_TAB_PRIVS where grantee='TEST';
把grant select any table to clerp;改成:grant select on user.table1 to clerp; 再试试
你少了一句:
grant connect to clerp
select * from dba_role_privs where grantee='USERNAME';
查看用户拥有的系统权限:
select * from DBA_SYS_PRIVS where grantee='USERNAME';
查看用户拥有的表权限:
select * from DBA_TAB_PRIVS where grantee='TEST';