Re: SYSTEM and SYSAUX Tablespace Opinions Requested

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.
Those account probably have the RESOURCE role granted. In previous releases (it started with 8.0, iirc), RESOURCE had 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.

SYSTEM - OK, SYSAUX, why not? A TS just as any other. Oracle just picked up the many complaints they advocate not to use the system tablespace for applications, and still do it themselves. Here comes SYSAUX: Yet another TS, oracle can rely on to exist.

>
> 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.
>

That has already been indicated.

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG4EoULw8L4IAs830RApNzAKCazUgnt/wg8GuqQYY+XB0D4t1MMwCgnBtd ApihTJSymfZLV9iRL6m/E8s=
=aqG4
-----END PGP SIGNATURE----- Received on Thu Sep 06 2007 - 13:42:28 CDT