Re: PL/SQL: execute immediate
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Fri, 16 May 2003 12:15:04 +0200
Message-ID: <1053079627.373143_at_news.thyssen.com>
Date: Fri, 16 May 2003 12:15:04 +0200
Message-ID: <1053079627.373143_at_news.thyssen.com>
Hi,
this is a very common asked one. As roles are disabled when you compile / execute a procedure with definer rights, you simply don't have the privilege to create tables in the schema. If you run you procedure with 'AUTHID CURRENT_USER', all privileges (even through roles) are checked at runtime.
Please do some googling before posting ;-))
hth,
Guido
Received on Fri May 16 2003 - 12:15:04 CEST