Re: revoke create/alter/drop tablespace

On Sat, 08 Oct 2005 13:58:03 -0700, Chan interested us by writing:

> Is there any way we can revoke CREATE/ALTER/DROP TABLESPACE from a
> user.
> I am using ORACLE v9.2 on AIX.
>
> Thanks.

SQL Reference Manual (at http://docs.oracle.com) Chapter 17, under 'GRANT' section

Copied here for your convenience, as it seems easier to ask in a newsgroup than to look it up in the docco,

"

System Privilege Name 	 Operations Authorized
CREATE TABLESPACE        Create tablespaces
ALTER TABLESPACE         Alter tablespaces
DROP TABLESPACE          Drop tablespaces
MANAGE TABLESPACE        Take tablespaces offline and online 
                            and begin and end tablespace backups

thus, from a userid with appropriate authority and using an appropriate tool you would run

   REVOKE CREATE TABLESPACE, ALTER TABLESPACE, DROP TABLESPACE FROM user;

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***