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

Home -> Community -> Usenet -> c.d.o.misc -> Re: can't create table from package

Re: can't create table from package

From: <andized_at_gmx.net>
Date: Sat, 8 Dec 2007 05:54:06 -0800 (PST)
Message-ID: <efcec0e2-6b34-491e-a6ca-46594b53dfe3@f3g2000hsg.googlegroups.com>


i already solved my little problem:
if a procedure (or a procedure inside a package) is executed roles are disabled and so are all grants inside these roles... my user got CREATE TABLE rights through a role, so it was disabled too.

hope this will help anybody with similar problems. Received on Sat Dec 08 2007 - 07:54:06 CST

Original text of this message

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