Q: What's wrong with this query (SQLPlus aborts on me)?

From: Simon Goland <sg_at_mda.ca>
Date: 1997/01/07
Message-ID: <32D280FC.47C5@mda.ca>#1/1

Something that seems very simple to me - just trying to find all the tables and the privileges the roles/users have. The query is:

SELECT r.granted_role,
       r.grantee,
       t.table_name,
       t.privilege
FROM   dba_role_privs r,
       dba_tab_privs t

WHERE r.grantee = t.grantee
ORDER BY r.granted_role, r.grantee, t.table_name;

When I run it, nothing happens for several seconds, and then I am kicked out of SQLPLus to Unix prompt. No error messages, except for a suspicious ORA-07445 in the alert log (is it related?). It does run OK when I restrict the scope of the query with the addition of 'AND r.grantee = <some specific user>' to the WHERE clause.

Do I need to increase some buffer/memory space somewhere for that? I am running it on 7.3.2.1.0 as SYSTEM.

Thanks,

-- 


[ Simon Goland            sg_at_mda.ca ]

[                B-)>               ]

[ Without action there is no change ]

Received on Tue Jan 07 1997 - 00:00:00 CST