Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora-04060 insufficient privs to execute procedure

Re: ora-04060 insufficient privs to execute procedure

From: Ken Komoto <kgkomoto_at_ucdavis.edu>
Date: Thu, 01 Jun 2000 13:20:17 -0700
Message-Id: <10515.107467@fatcity.com>


It's a grants problem. When you say same account, is the webserver logging into oracle with the same account you use in client/server? However the DAD or cartridge was setup, it's probably a different userid (like owa_user or www_user). That userid is missing grants to execute the package...

At 12:13 PM 6/1/00 -0800, Cale, Rick T (Richard) wrote:
>Hi,
>
>I am not sure if this went thru the first time.
>I have package that runs perfectly in client/server. When I try to run the
>same package on the
>web under the same user account I get ora-04060. Does anyone have any idea
>why it behaves
>differently on the web.
>Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists


Kenneth Komoto			Email: kgkomoto_at_ucdavis.edu
Office of the Registrar	Phone: (530)752-7197
University of California	Fax  : (530)752-0329
Received on Thu Jun 01 2000 - 15:20:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US