Re: admin user for one tablespace

Don't want to do GRANT CREATE ANY ... or GRANT DROP ANY ... because the user will have access to create and drop any table in Database.

Try revoking:

     revoke unlimited tablespace to <user>;

And then, grant quota to user on this tablespace:

     alter user <user> 
              quota unlimited on <tablespace_name>;