#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2014
    Posts
    21
    Rep Power
    0

    Accessing System objects


    All,


    Procedure created under SYS and granted the privlege "Grant execute on <Procedure-name> to public.

    Later when executed the procedure by logging into one of the schema i am getting the error PLS-00201/Identifier must be declared.

    What else i need to grant.

    Thanks
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    867
    Rep Power
    392

    Talking


    If the procedure access' table(s), then you may have to grant adequate permissions on those tables to the user executing the procedure.

IMN logo majestic logo threadwatch logo seochat tools logo