可以用如下方法进行查询：

--sysdba用户创建U1,U2两个用户
create user u1 identified by 123456789;
create user u2 identified by 123456789;

--将u1的所有权限赋予u2（需要先执行sp_set_para_value(2,'GRANT_SCHEMA',1)，并重启数据库)
grant all privileges on u1 to u2;

--查询u2对象权限
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','U2') FROM DUAL;
结果如下：
GRANT SELECT ON U1 TO U2
GRANT FLASHBACK ON U1 TO U2
GRANT INDEX ON U1 TO U2
GRANT ALTER ON U1 TO U2
GRANT WRITE ON U1 TO U2
GRANT READ ON U1 TO U2
GRANT SELECT FOR DUMP ON U1 TO U2
GRANT USAGE ON U1 TO U2
GRANT EXECUTE ON U1 TO U2
GRANT REFERENCES ON U1 TO U2
GRANT UPDATE ON U1 TO U2
GRANT DELETE ON U1 TO U2
GRANT INSERT ON U1 TO U2