Question:

I am trying to create a different tablespace for an indices, tables,
and temporary object for a schema.

I create the tablespaces, create the user with default tablespace to
the one for tables and the temporary tablespace to the one for temp
objects.

When I create a table and put it in a tablespace and then try to create
the index and put it in a seperate tablespace I get a:

ORA-01950: no privileges on tablespace

error.  I've tried to grant MANAGE TABLESPACE, ALTER TABLESPACE, CREATE
TABLESPACE, DROP TABLESPACE to the user but it does not solve the
problem.  Any help would be greatly appriciated.

Answer:

Try this:

ALTER USER scott
QUOTA UNLIMITED ON tablespace;

or

ALTER USER scott
QUOTA x [k|M] ON tablespace;