Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Knoxville, TN USA
    Posts
    2

    Unanswered: OCI-22303: type "CATS"."CUSTADDRESS2" not found

    Type does exist howerver... when connected as Type owner "CATS" no error. Does Type need privs granted to user?

    thanks,
    K

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    As user CATS, execute :

    Code:
    GRANT EXECUTE ON CUSTADDRESS2 TO user;
    where user is the user that should access the type.

    HTH & Regards,

    RBARAER

  3. #3
    Join Date
    Dec 2003
    Location
    Knoxville, TN USA
    Posts
    2
    Very Good - Thanks
    KPR

Posting Permissions

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