This discussion is archived
3 Replies Latest reply: Feb 16, 2013 10:33 PM by Osama_Mustafa RSS

Privs

user13809017 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points