오라클 REVOKE

REVOKE 오라클 권한 제거

SELECT 'REVOKE  '||PRIVILEGE||' ON '||OWNER||'.'||TABLE_NAME||' FROM '||GRANTEE||';' DDL
     , A.*
  FROM DBA_TAB_PRIVS A
 WHERE A.TYPE = 'SEQUENCE'
   AND A.GRANTEE IN ('소유자')
   AND A.PRIVILEGE = 'ALTER'      
  ;