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: Oradba Linux <oradba_linux_at_comcast.net>
Date: Sat, 27 Nov 2004 21:23:13 GMT
Message-ID: <5f6qd.573981$mD.163560@attbi_s02>


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
>

To create a table in system any user would need create table privilege and quota on system tablespace.

I hope this helps. Received on Sat Nov 27 2004 - 15:23:13 CST

Original text of this message

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