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: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 8 Oct 2005 23:13:33 +0200
Message-ID: <4348364e$0$17980$626a14ce@news.free.fr> 






"Chan" <chandra_2000_us_at_yahoo.com> a écrit dans le message de news: 1128805083.749910.163880_at_g43g2000cwa.googlegroups.com...


| Is there any way we can revoke CREATE/ALTER/DROP TABLESPACE from a

| user.

| I am using ORACLE v9.2 on AIX.

|

| Thanks.

|




revoke create tablespace, alter tablespace, drop tablespace from <user>;
revoke <all roles containing the previous privileges> from <user>;



Regards


Michel Cadot
Received on Sat Oct 08 2005 - 16:13:33 CDT












Original text of this message













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