Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: revoke create/alter/drop tablespace

Re: revoke create/alter/drop tablespace

From: HansF <News.Hans_at_telus.net>
Date: Sat, 08 Oct 2005 21:15:02 GMT
Message-Id: <pan.2005.10.08.21.13.46.700577@telus.net>


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 ***
Received on Sat Oct 08 2005 - 16:15:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US