3 Replies Latest reply: Feb 17, 2013 12:33 AM by Osama_Mustafa RSS

    Privs

    user13809017
      Hi,


      We using 10.2 on Aix5.

      The user asking to give permission(role) to package body.
      How to check what are the privileges package body having?

      Thanks
        • 1. Re: Privs
          sb92075
          user13809017 wrote:
          Hi,


          We using 10.2 on Aix5.

          The user asking to give permission(role) to package body.
          How to check what are the privileges package body having?

          Thanks
          Privileges acquired via ROLE do NOT apply within named PL/SQL procedures.
          the only privilege that is meaningful to a package is EXECUTE.
          • 2. Re: Privs
            Chanchal Wankhade
            Hi,

            In case, you have to assign execute privilege to the user.
            Syntax is
            Connect as sysdba
            
            SQL> grant EXECUTE on objectname to username;
            
            grant execute on package_name  to username;
            • 3. Re: Privs
              Osama_Mustafa
              user13809017 wrote:
              Hi,


              We using 10.2 on Aix5.

              The user asking to give permission(role) to package body.
              How to check what are the privileges package body having?

              Thanks
              You grant him Execute , Also Check the below document :
              http://docs.oracle.com/cd/B13789_01/network.101/b10773/authoriz.htm