Re: CREATE TABLE in stored procedure

Sven Heins wrote:
>
> Hi,
>
> I'd like to create a table in a package or stored procedure with dynamic
> SQL using DBMS_SQL package.
>
> Problem:
> I have rights to create a table and I can use the coding in an anonymous
> PL/SQL block (with the same USER connected to the database) but I can't
> execute a procedure with this coding successfully.
> The owner of the procedure is the same USER and the execution of the
> procedure is made with this USER but I have still right problems!!!
>
> What is wrong???
>

Hallo Sven

A procedure does not recognize the right " CREATE TABLE " if granted by a role !

The System-privileg has to be granted explicitly to the user

for example: GRANT CREATE TABLE to SVEN (if sven is your user name)

Moin ,Moin Received on Wed Dec 09 1998 - 00:00:00 CST