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

Home -> Community -> Usenet -> c.d.o.misc -> Re: admin user for one tablespace

Re: admin user for one tablespace

From: replace this with _at_ <_at_)xs4all.nl>
Date: Tue, 06 Oct 1998 20:25:38 GMT
Message-ID: <361a7c21.1655951@news.xs4all.nl>


Hi,

>I have a user who needs all create,drop etc on all tables within one
>tablespace. I tried 'grant all on tablespace1 to csm' but that did not
>do what I wanted to to do. What would be the best way to do this?

Try
GRANT CREATE ANY TO ...
GRANT DROP ANY TO ...
etc..


Received on Tue Oct 06 1998 - 15:25:38 CDT

Original text of this message

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