Results 1 to 2 of 2

Thread: Privilegies

  1. #1
    Join Date
    Jun 2003

    Unanswered: Privilegies

    Hello !!

    I have a kind of architecture in Oracle 8i like this:

    1)In the Sys I did: Grant select on V$SESSION to user1
    2)In user2 I Created a view of V$SESSION called view1 and a package called pck1 with procedure inside that uses view1 to kill sessions.
    3) Later I did: Gran execute on pck1 to user2
    4) I created a package called pck1 with a procedure in user2 inside that executes pck1.sp_killsession and it throws this error:

    ORA-01031: insufficient privileges
    ORA-06512: at "user1.pck1", line 14
    ORA-06512: at "user2.pck2", line 29
    ORA-06512: at line 3

    What is going On ?????????
    Last edited by jortiz; 05-10-04 at 18:19.

  2. #2
    Join Date
    Mar 2004
    Did you grant the select on v$session to user1 via a role? Packages run against permissions granted directly to the user that creates them and not via roles.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts