1 2 Previous Next 16 Replies Latest reply on Sep 27, 2013 1:46 AM by Hemant K Chitale

    revoking SELECT ANY DICTIONARY from public caused connections to the DB to hang

    user9074881

      I don't know why it occurred, but revoking SELECT ANY DICTIONARY from public caused connections to the DB to hang.

       

      DECLARE

      BEGIN

       

       

           FOR l IN (select privilege from dba_sys_privs where privilege in ('SELECT ANY DICTIONARY') and grantee='PUBLIC')

           LOOP

                 EXECUTE IMMEDIATE 'REVOKE '||l.privilege||' FROM PUBLIC';

           END LOOP;

       

       

      END;

      /

       

      Any insight into the problem would be appreciated.

       

      Thank you

        1 2 Previous Next