1 Reply Latest reply on May 21, 2012 8:01 PM by Srini Chavali-Oracle

    To  identify privilege granted to public is optional & can be revoked

    user200744
      Dear All,

      Kindly help me to know the way/method to identify, because revoking all the privilege from public is disastrous

      1) Which default system/object/role privilege granted to public can be revoked?.
      2) Which object/system/role privilege granted to public is mandatory not to be revoked?

      Thanks in advance.
        • 1. Re: To  identify privilege granted to public is optional & can be revoked
          Srini Chavali-Oracle
          This issue has been discussed before in these forums - and there is a no single answer that can be applied uniformly. You will need to first identify what privileges have been granted to PUBLIC, then revoke them one by one and test your application after each revoke.

          https://forums.oracle.com/forums/search.jspa?threadID=&q=public+AND+revoke&objID=c18&dateRange=all&userID=&numResults=15

          Default Privileges Assigned To PUBLIC [ID 759684.1]     
          Be Cautious When Revoking Privileges Granted to PUBLIC [ID 247093.1]     

          HTH
          Srini