| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> 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 - 04:57:51 CDT
![]() |
![]() |