Re: execute immediate

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Mon, 30 Oct 2000 06:16:44 -0500
Message-Id: <10665.120556@fatcity.com>

you're getting the privileges thru a role in sqlplus,

depending on that the sql stmt is trying to do is what privileges you need.

joe
"DEMANCHE Luc (Cetelem)" wrote:
>
> Hi,
>
> Which privilege do I need to do 'execute immediate' in stored proc ?
> It works in sqlplus, but when I call the stored proc, I need more
> privileges ?
>
> TIA
>
> Luc Demanche
> CETELEM
> 01-46-39-14-49

-- 
Joe Testa  http://www.oracle-dba.com
No you can't fix an ORA-600 error, call Oracle Support.

Received on Mon Oct 30 2000 - 05:16:44 CST