Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: creating tables in SYSTEM
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