Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYSTEM and SYSAUX Tablespace Opinions Requested
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.orgReceived on Thu Sep 06 2007 - 09:07:03 CDT