CREATE PROCEDURE P () BEGIN CREATE MULTISET TABLE Test (N SMALLINT); END;
SPL1078:E(L2), User is not authorized to use the DDL/DCL/Dynamic SQL statement.
I've granted all the rights to the user, and it doesn't work.
If I try it with the sysdba user, it's ok, the procedure gets created in the sysdba database, and it works, but I don't want to do that. I need to do it in a particular database. I think the user has the same rights as sysdba... what am I doing wrong?