Re: tablespace SYSTEM used by others user, not sys. Help!

hi, x
dev_user only have priviledge to create table under his own tablespace which is dev_user only. he only granted the priviledge 'create table' not 'create any table'

"x" <x_at_x.hr> wrote in message news:<c9p4i6$ndq$1_at_ls219.htnet.hr>...
> >I wonder, how can the table
> > created by them is in system schema? Pls let me know, if u have the
> > answer.
> >
>
> create table my_table (x varchar2(1)) tablespace system
>
> Easy as that. If your dev_user has right priviledges he can create table
> where ever he wants.
Received on Fri Jun 04 2004 - 11:57:51 CEST