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

termopilucco wrote:

>There's is any way for an Oracle DBA to revoke permission from an user like
>alter *HIS* tablespace structure?
>E.g. Can'I unallowe user SCOTT to add table in SCOTT tablespace?
>
>thanks in advance,
>x:termoPilucco, sorry for my bad english.
>
>

What Brian said.

But, in addition, there is no such thing as SCOTT tablespace. Log on as SCOTT and perform the
following:

SELECT table_name, tablespace_name
FROM user_tablespaces;

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>;

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

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)