Re: admin user for one tablespace

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

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---