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>


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',

'A','Design',
'G','Admin') Priv
from dba_tab_grants where owner = 'SYSTEM' and table_name = 'MENU_B_USER' order by 1,2,3;
Received on Fri Jun 05 1992 - 17:57:23 CEST

Original text of this message