Re: QUOTA Question

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sun, 2 Sep 2007 20:10:45 -0400
Message-ID: <4iICi.1693$3Y1.432@newssvr17.news.prodigy.net>

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1188777119.105107.143230_at_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 --
>

Thank you very much for clearing up my confusion. Received on Sun Sep 02 2007 - 19:10:45 CDT