DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: grant execute on xyz to user

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    Hi Everybody ,

    I have created a package named pkg1 then i created package body pkg1.there are two procedures (p()startup,p()emp_table)in this package.
    Now the prob is i want to grant execute previledge to a particular user..

    Grant execute on pkg1 to xyz;

    it gives me grant succeded.

    but when i run the second p()emp_table i get
    identifier 'PKG1.EMP_TABLE' must be declared

    i again tried to grant the execute previledge on the proc emp_table...using

    GRANT EXECUTE ON PKG1.EMP_TABLE TO XYZ;

    i am getting

    ORA-04042: procedure, function, package, or package body does not exist

    what i am doing wrong..pls help

    Thanks in advance
    Pras

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    exec owner.PKG1.EMP_TABLE()

  3. #3
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    Hi Pando

    I am still getting the error..

    SQL> GRANT EXECUTE ON ACPART.PKG1.EMP_TABLE TO PUBLIC;
    GRANT EXECUTE ON ACPART.PKG1.EMP_TABLE TO PUBLIC
    *
    ERROR at line 1:
    ORA-00905: missing keyword

    THANKS
    pras

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Did the 2nd user (XYZ) ran:

    Code:
    EXEC USER_1.PKG1.EMP_TABLE;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hmm I dont think I said anything about grant did I


  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    hmm I dont think I said anything about grant did I

    I don't think so :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Jul 2000
    Location
    india
    Posts
    213

    Thanks

    Hi Pando/Julian

    Actually i am using these procedures in Portal 3.0..Anyway after closing the instance and again starting i am able to run the procedure.

    Thanks again
    pras

Posting Permissions

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


Click Here to Expand Forum to Full Width