Re: SQLMenu privs question
From: <KML110_at_psuvm.psu.edu>
Date: 5 Jun 92 15:57:23 GMT
Message-ID: <92157.115723KML110_at_psuvm.psu.edu>
Date: 5 Jun 92 15:57:23 GMT
Message-ID: <92157.115723KML110_at_psuvm.psu.edu>
Here's how to list out SQL*Menu privs by grantee and grantor. Note that if
there have been multiple grantors, you have to revoke from both accounts in
order to remove all menu privs for the user.
break on grantee skip 1 on grantor
set pagesize 60
select grantee, grantor,
decode(insert_priv,'N','Execute',Received on Fri Jun 05 1992 - 17:57:23 CEST
'A','Design',
'G','Admin') Priv
from dba_tab_grants where owner = 'SYSTEM' and table_name = 'MENU_B_USER' order by 1,2,3;