Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PRIVILEGE PROBLEMS USING EXECUTE IMMEDIATE!

PRIVILEGE PROBLEMS USING EXECUTE IMMEDIATE!

From: Bullseye <no email>
Date: Mon, 28 Nov 2005 19:01:29 +0000
Message-ID: <50lmo1hnd1l7u7l1i0ghloljb22pfe1vm9@4ax.com>


Can anyone help me.

I have a table in SCHEMA1:=

create table TESTTAB (Dummy varchar2(10) ); grant alter,insert, update, delete, select ON TESTTAB to SCHEMA2

Within SCHEMA2 I can do:-
truncate table SCHEMA1.TESTTAB;

But The following aborts with a Insufficient privileges:-

create procedure DoIt IS
BEGIN
   execute immediate 'TRUNCATE TABLE SCHEMA1.TESTTAB'; END; BEGIN
   DoIt;
END; There must be some additional privileges needed to use execute immediate across Schema's. (these all work if all objects are in the same Schema!

TIA Received on Mon Nov 28 2005 - 13:01:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US