Error creating a user in Oracle

0

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.

    
asked by A arancibia 12.04.2018 в 16:05
source

0 answers