Re: Error

Hi,

       grant execute any procedure to the user.

Raman

• Message History ----------------------------------------

From: turner_at_tellme.com on 13/09/2000 02:11 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: Error

I am getting an error

BEGIN test_p; END;

*
ERROR at line 1:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "OPS$ORACLE.TEST_P", line 7
ORA-06512: at line 1

when I try to run a stored procedure that uses dbms_sql to create a table. I granted the user DBA temporarily just to see how it worked while I figure out what I have forgotten and still get the error.

Any idea?

Thanks, Dave Turner

--
Author: David Turner
  INET: turner_at_tellme.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).