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: creating tables in SYSTEM

Re: creating tables in SYSTEM

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 28 Nov 2004 22:45:49 -0800
Message-ID: <1101710658.140502@yasure>


vertigo wrote:

> Hello
>
> DOes every user have the possibility to create tables in SYSTEM
> tablespace ? If yes how can i prevent it ? If not what 'block such
> command' (privilegdes or something like this ?) ?
>
> Thanx
> Michal

Only if it is granted to them explicitly by a DBA that is ignorant of the consequences or implicitly by a DBA taht is ignorant of what they are doing and the consequences.

A good rule of thumb for creating users would be to start with a template such as this:

CREATE USER <user_name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <tablespace_name>
TEMPORARY TABLESPACE <temp_tablespace_name> QUOTA 0 ON SYSTEM
QUOTA 0 ON SYSAUX; -- for 10g only

Then grant specific tablespace quota and system privleges as are appropriate.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 29 2004 - 00:45:49 CST

Original text of this message

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