How do I grant CREATETAB on selected tablespace and not on entire database?

Thanks,
j

You can make use of "USE" privilege(tablespace level).

Regards
Prakash

USE is not allowing users to create tables in that tablespace. Is there any other way to do this. We just want to give them create table access to only one tablespace and not on entire database.

Thanks,
j

Grant CREATETAB on database and then USE OF TABLESPACE only for the tablespace ..

For eg, if you want user TEST1 to create tables in TEST1_TS, then

revoke createtab on database from public
revoke use of tablespace test1_ts from public
grant createtab on database to user test1
grant use of tablespace test1_ts to user test1_ts

HTH

Sathyaram