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: SYSTEM and SYSAUX Tablespace Opinions Requested

Re: SYSTEM and SYSAUX Tablespace Opinions Requested

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 06 Sep 2007 07:07:03 -0700
Message-ID: <1189087616.823042@bubbleator.drizzle.com>


Dereck L. Dietz wrote:
> In the database I work on at work it appears that there are many user
> accounts which have been created with the system privilege UNLIMITED
> TABLESPACE.
>
> I brought this to the attention of my manager mentioning that no user
> account should have any tablespace quota in those two tablespaces. He had
> me write it up and then forwarded it to the off-site DBA to see what he
> thought of my suggestions.
>
> On the off-chance (but still possible) that this DBA says that it's nothing
> to worry about what comments do any of you have on having user accounts that
> have quota in those two tables as well as some that have the SYSTEM
> tablespace as the default temporary tablespace.
>
> Thanks.

Let me say this as gently as possible: Fire the DBA and find someone competent.

If your management doesn't want to hear that message from you then feel free to suggest they contact me directly.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Sep 06 2007 - 09:07:03 CDT

Original text of this message

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