I'm trying to create a user in Oracle and I get the error
can not specify temporary tablespace as default tablespace
This is what I am trying to do:
create user testuser
identified by "test"
default tablespace temp
temporary tablespace ttemp;
-- System Privileges for testuser
grant create any synonym to testuser;
grant create session to testuser;
GRANT SELECT ANY TABLE TO testuser;
-- Object Privileges for testuser
grant select on SYSMAN.TESTORACLE to testuser;
I've been reading and I can not find what I'm doing wrong.