为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。 【DM版本】:dm8 【操作系统】：凝思 【CPU】:64 【问题描述】*：如何统计A用户给B模式中的哪些表开了只读权限和读写权限
SELECT grantee,owner, table_name, LISTAGG(privilege, ‘,’) WITHIN GROUP (ORDER BY table_name) AS permissions FROM dba_tab_privs WHERE grantee = ‘B’ AND owner LIKE ‘A%’ GROUP BY grantee,owner, table_name; 试下这个sql语句，模拟了一下，可以查到的，你也可以本地试一试
SELECT grantee,owner, table_name,
LISTAGG(privilege, ‘,’) WITHIN GROUP (ORDER BY table_name) AS permissions
FROM dba_tab_privs
WHERE grantee = ‘B’
AND owner LIKE ‘A%’
GROUP BY grantee,owner, table_name;
试下这个sql语句，模拟了一下，可以查到的，你也可以本地试一试