Re: QUOTAS ON TEMPORARY TS
From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1996/08/10
Message-ID: <DvwJJB.52M_at_matilda.vut.edu.au>#1/1
Date: 1996/08/10
Message-ID: <DvwJJB.52M_at_matilda.vut.edu.au>#1/1
Alexander Bardos (alexbrds_at_unix.infoserve.net) wrote:
: I am getting rid of the UNLIMITED TABLESPACE system privilege that comes
: with the RESOURCE and DBA roles.
: We have a separate tablespace for temporary segments.
: QUESTION: Do the users need explicit quota on their temporary tablespace
: or is it handled implicitly by the server ? Obviously I am giving the
: users quotas on tablesopaces where their schema objects live.
It's implicit when you say "temporary tablespace TEMP". No quotas need be assigned unless the user is actually going to store some permanent objects in there.
Leng.
-- Leng Kaing DBA - Directory Technology P/L Email: lkaing_at_ventnds1.telecom.com.au Ph: +61-3-9892-9081 Fax: +61-3-9892-9344 WWW: http://www.vut.edu.au/vougReceived on Sat Aug 10 1996 - 00:00:00 CEST