Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!news.mixmin.net!proxad.net!feeder1-2.proxad.net!64.233.178.134.MISMATCH!postnews.google.com!c4g2000hsg.googlegroups.com!not-for-mail From: andized@gmx.net Newsgroups: comp.databases.oracle.misc Subject: Re: can't create table from package Date: Wed, 12 Dec 2007 07:22:52 -0800 (PST) Organization: http://groups.google.com Lines: 37 Message-ID: References: <2f8370dd-e238-4d4d-a7e2-188b349b8c1a@y5g2000hsf.googlegroups.com> NNTP-Posting-Host: 62.154.222.235 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1197472977 1245 127.0.0.1 (12 Dec 2007 15:22:57 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 12 Dec 2007 15:22:57 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: c4g2000hsg.googlegroups.com; posting-host=62.154.222.235; posting-account=3_B_hgoAAAAHeDwT80t9s0vQYG6kL16R User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 G8NMC (NetCache NetApp/6.0.4P1), 1.1 G8NMC (NetCache NetApp/6.0.4P1) Xref: usenetserver.com comp.databases.oracle.misc:250993 X-Received-Date: Wed, 12 Dec 2007 10:22:57 EST (text.usenetserver.com) it was part of a package i had to port. the original author said dropping & creating these tables was faster than performing a truncate. i meanwhile replaced the CREATEs with ALTER statements. btw, the CREATEs were not the most evil part in the original package ;) AndiZed On 10 Dez., 18:34, Ed Prochak wrote: > On Dec 8, 8:22 am, andi...@gmx.net wrote: > > > > > Hello, > > > i am having trouble creating tables from a package using oracle 10g. > > i am logged in as user 'testuser' and am working in the users schema > > 'testuser' where the user is allowed to perform CREATE TABLE > > statements, also the EXECUTE right is granted. but when i execute a > > package with a statement like EXECUTE IMMEDIATE 'CREATE TABLE ...'; i > > receive a ORA-01031 (insufficient privileges). if i execute the create > > statement from an editor window the table will be successfully created > > since i am granted CREATE TABLE. > > > it looks like the grants of the users session are changed when i am > > inside a package, but i am wondering why this should make any sense > > and how i can get the GRANTS to work inside a package too. > > > any ideas? help would be highly appreciated! > > AndiZed > > Why would you want to do this in the first place? > > this is just dangerous practice. Don't do it. > Ed