–将其中的 CESHI 替换为要创建的用户名即可
–用户默认密码： Dameng@123
–通用机创建用户 CESHI
–创建用户默认表空间
CREATE TABLESPACE “CESHI01_DATA”
DATAFILE ‘CESHI_DATA_01.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
‘CESHI_DATA_02.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
–创建用户索引表空间
CREATE TABLESPACE “CESHI02_INDEX” DATAFILE
‘CESHI_INDEX_01.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600,
‘CESHI_INDEX_02.DBF’ SIZE 1024 AUTOEXTEND
ON NEXT 1024 MAXSIZE 409600 CACHE = NORMAL;
–创建用户
CREATE USER “CESHI” IDENTIFIED BY “Dameng@123”
ENCRYPT BY OPENSSL_SM3
DEFAULT TABLESPACE “CESHI01_DATA”
DEFAULT INDEX TABLESPACE “CESHI02_INDEX”
;

GRANT “PUBLIC”,“RESOURCE”,“SOI”,“SVI”,“VTI” TO “CESHI”;
–根据实际需求 考虑是否授予DBA角色
– GRANT “DBA” TO “CESHI”;