create user命令
create user username identified by pword
default tablespace spname
temporary tablespace tmpspname;
create user username identified by pword
default tablespace spname
temporary tablespace tmpspname;
CREATE USER "SED" IDENTIFIED BY "pass" DEFAULT TABLESPACE "TS_UTILITY_DAT" TEMPORARY TABLESPACE "TEMPORARY_DATA" PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT "CONNECT" TO "SED" WITH ADMIN OPTION;
GRANT "DBA" TO "SED" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "SED" WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO "SED";
ALTER USER "SED" DEFAULT ROLE ALL;在ORCLE8.1.6不能通过 ,请问该如何修改?
DEFAULT TABLESPACE "TS_UTILITY_DAT" TEMPORARY TABLESPACE "TEMPORARY_DATA" PROFILE DEFAULT ACCOUNT UNLOCK;
运行成功了
我想可能是
"TS_UTILITY_DAT"
"TEMPORARY_DATA"变了位置了
但是现在的位置在哪里呢?