Re: [?][Newbie] Permission on user tablespace

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote:

> What Brian said.

Ok, thanks to either.

> If you wish to grant permission for SCOTT to use a different
> tablespace look at:

> ALTER USER scott
> QUOTA 10M ON <tablespace_name>;
> or
> ALTER USER scott
> QUOTA UNLIMITED ON <tablespace_name>;

So, if i want to deny user SCOTT to alter a specific tablespace structure, i have to execute

ALTER USER scott
QUOTA 0 ON <tablespace_name>;

Anyway SCOTT can add/delete/update records on <tablespace_name>. Ok sorry, i run to RTFM :)

> Making sure you don't grant quota on SYSTEM, UNDO, RBS, or TEMP.

Thanks,
x:termoPilucco, sorry for my bad english. Received on Thu Oct 09 2003 - 11:01:13 CDT