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

Home -> Community -> Usenet -> c.d.o.server -> Re: Import to wrong tablespace!

Re: Import to wrong tablespace!

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 4 Dec 2003 14:16:12 GMT
Message-ID: <3FCF41AC.2982EDEE@remove_spam.peasland.com>


> Frankly I've never understood why this quota 0 on system is recommended.
> If a user has unlimited tablespace privilege then quota 0 on system won't do anything?
> So why bother?

That is true. So QUOTA 0 on SYSTEM is only valid if UNLIMITED TABLESPACE is revoked. I'm pretty sure Daniel will tell you that as well.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Thu Dec 04 2003 - 08:16:12 CST

Original text of this message

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