Re: creating tables in SYSTEM

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Sat, 27 Nov 2004 21:37:44 GMT
Message-ID: <Is6qd.24849$Rf1.21925@newssvr19.news.prodigy.com>

"vertigo" <ax178_at_wp.pl> wrote in message news:coapht$532$1_at_atlantis.news.tpi.pl...
> 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
>

The idea is that of a schema.
That is a user ID with create table, a default tablespace (not system), a default temporary tablespace (not system), and quota (unlimited on the tablespaces (no system) you wish).

Note: do not grant resource to any such user ID, it has unlimited tablespace which will allow creating objects in
system. The connect role has privs that allow a user to create ordinary objects. Received on Sat Nov 27 2004 - 15:37:44 CST