Re: PL/SQL privileges

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 20 May 2004 12:46:22 +0000 (UTC)
Message-ID: <c8i9au$r7d$1@titan.btinternet.com>

Check this for relevance

http://www.jlcomp.demon.co.uk/faq/plsql_privs.html

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Jon" <aaa_at_bbb.ccc> wrote in message news:c8hvrf$6mc$1_at_unbe.sarenet.es...


> Hi,

>

> A user has "create any table" privileges and the same user has a procedure

> with

>

> "execute immedate 'create table ...'"

>

> when the user tries to run the procedure, it returns the following error

>

> "ORA-01031: insufficient privileges"

>

> thanks

>

>

Received on Thu May 20 2004 - 07:46:22 CDT