Re: Error

using dbms_sql you can't get the privileges thru a role, they HAVE to be granted EXPLCITLY to the user.

hth, joe
David Turner wrote:
>
> 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).

-- 
Joe Testa  http://www.oracle-dba.com