From: "Verna Legaspi" Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server Subject: Re: designer webserver library (wsgl?) problems Date: Mon, 9 Oct 2000 16:55:26 -0700 Organization: AT&T Wireless Services InterNetNews Site Lines: 41 Message-ID: <8rtloq$e5g$1@redftp.redftp.attws.com> References: <8rj68e$7kl$1@redftp.redftp.attws.com> <39E04833.609732D8@home.nl> <39E20222.32D67771@home.nl> NNTP-Posting-Host: 141.204.179.103 X-Trace: redftp.redftp.attws.com 971135578 14512 141.204.179.103 (9 Oct 2000 23:52:58 GMT) X-Complaints-To: ensg-wks@attws.com NNTP-Posting-Date: 9 Oct 2000 23:52:58 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 I've checked - all the tables being accessed are already owned by bob. Therefore, I cannot grant bob access to his own stuff. Also... what do you mean "invokers' stuff?" Invoker meaning schema/user who executed the procedure? (In my case, this would be bob) Just to make sure I explained correctly - the bob schema has all the tables. The wsgl_public schema just has the wsgl packages such as wsgl, wsglm, and wsgjsl. Where it seems to be failing is in this code: ----------------- function QueryHits( P_GLOS_CATEGORY1 in varchar2, P_GLOS_CATEGORY2 in varchar2, P_GLOS_CATEGORY3 in varchar2, P_GLOS_OWNER in varchar2) return number is begin if not BuildSQL(P_GLOS_CATEGORY1, P_GLOS_CATEGORY2, P_GLOS_CATEGORY3, P_GLOS_OWNER) then return -1; end if; return WSGL.CountHits(ZONE_SQL); exception when others then WSGL.DisplayMessage(WSGL.MESS_EXCEPTION, SQLERRM, ''||' : '||'', BODY_ATTRIBUTES, 'GLOSMAIN2$GLOSTRM.QueryHits'); return -1; end; ----------------- We get that "-1" instead of an actual hit count. Skimming through the code - all the tables are owned by bob, so it can't be a no SELECT priv issue, can it? Sorry for throwing all that code at you. I'm just not good enough of a debugger to narrow it down further.