--2025年前通用机创建用户--说明：替换所USERNAME为用户名，注意修改密码
CREATE TABLESPACE "USERNAME01_DATA"
DATAFILE 'USERNAME_DATA_01.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
'USERNAME_DATA_02.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
--创建用户索引表空间
CREATE TABLESPACE "USERNAME02_INDEX" DATAFILE
'USERNAME_INDEX_01.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
'USERNAME_INDEX_02.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
--创建用户
CREATE USER "USERNAME" IDENTIFIED BY "密码" PASSWORD_POLICY 0
DEFAULT TABLESPACE "USERNAME01_DATA"
DEFAULT INDEX TABLESPACE "USERNAME02_INDEX";
--授权
GRANT "PUBLIC","RESOURCE","SOI","VTI"，"DBA" TO "USERNAME";

----25年后通用机创建用户
CREATE TABLESPACE "USERNAME01_DATA"
DATAFILE 'USERNAME_DATA_01.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
'USERNAME_DATA_02.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
--创建用户索引表空间
CREATE TABLESPACE "USERNAME02_INDEX" DATAFILE
'USERNAME_INDEX_01.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
'USERNAME_INDEX_02.DBF' SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
--创建用户
CREATE USER "USERNAME" IDENTIFIED BY "密码";
alter user "USERNAME" default tablespace "USERNAME01_DATA" default index tablespace "USERNAME02_INDEX";
--授权
GRANT "PUBLIC","RESOURCE","SOI","VTI"，"DBA" TO "USERNAME";