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

Home -> Community -> Usenet -> c.d.o.misc -> wierd pl/sql

wierd pl/sql

From: Nick <nick_j_at_mailcity.com>
Date: Wed, 05 Jan 2000 12:27:13 +1100
Message-ID: <38729DF0.9C9C1E5A@mailcity.com> 





Hi,



We are selecting data from websys.ows_content from the sql prompt, and
getting results back. But if we put the _same_ select statement in a
procedure, we encounter "PLS-00904: insufficient privilege to access
object WEBSYS.OWS_CONTENT"



We have successfully added the privleges for the user
(OWS_STANDARD_ROLE).


Thanks for any help.



Regards,



Nick.



Received on Tue Jan 04 2000 - 19:27:13 CST












Original text of this message













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