Re: QUOTA Question

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sun, 02 Sep 2007 16:51:59 -0700
Message-ID: <1188777119.105107.143230@y42g2000hsy.googlegroups.com>

On Sep 2, 6:32 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> I apologize if this is a dumn question ...
>
> If i set the quota for a user to 0 for SYSTEM and SYSAUX will that user be
> able to create stored procedures and packages?
>
> I'm not sure where such a package/procedure would be stored.

The package is just stored code within the rdbms base tables owned by user SYS so user quota privileges do not apply. Quota is applied to the table/index owner and not to the package owner.

HTH -- Mark D Powell -- Received on Sun Sep 02 2007 - 18:51:59 CDT