Re: DBMS_SQL and DBMS_OUTPUT package

On 29 Oct 1997 14:17:55 GMT, "Haresh Assumal" <assumal_at_sprynet.com> wrote:

>Hi,
>I have two questions that I hope someone can answer:
>
>I am trying to create a table using a PL/SQL procedure who's input
>parameter is the table name. I use the DBMS_SQL.PARSE procedure to do this.
>I can create the procedure sucessfully however when I try an execute it I
>get the following message:
>
>ORA-01031: insufficient privileges
>
>This message comes from my procedure where I trap all exceptions and print
>out the error message. I can create a table without this PL/SQL procedure
>in SQL so the user I am logining as has sufficient privileges and owns the
>procedure too. I am running the procedure from SQL. What's wrong?

You must be explicitly granted permission to create the table. The permission can't be granted through a role.

Pat Smith Received on Fri Oct 31 1997 - 00:00:00 CST