Re: Dynamic SQL

From: Heidi E. Schmidt <heidi_at_cybercom.net>
Date: Thu, 18 May 2000 14:37:54 -0400 (EDT)
Message-Id: <10501.106005@fatcity.com>

> A friend was trying to execute dynamic sql using EXECUTE IMMEDIATE (Create
> table ....) in his own schema but was getting insufficient privileges error.
>
> What's happening? Any special roles to be granted?
>
> The database version is Oracle8.1.5 on NT.
>
> Manish

Manish,

What the roles connect, dba, resource don't tell you is that it automagically includes "UNLIMITED TABLESPACE" You can grant create table, and other object creation abilities but unless unlimited tablespace privilege is given none of thoose grants apply.

So try granting that and then testing it. If that isn't the case note the oracle error and see what that leads to. Received on Thu May 18 2000 - 13:37:54 CDT