DM8:达梦数据库SQL创建用户-非DM8.2环境
环境介绍
- 在没有图形化界面,或者想快速创建用户,可以使用一下SQL语句;
- 将其中的 CESHI 替换为要创建的用户名即可,
- 默认创建了数据表空间,索引表空间,文件大小限制各是400GB,数据达到文件上限前,可以新增数据文件对表空间扩容;
- 用户密码: 用户名123456789
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 "CESHI123456789" PASSWORD_POLICY 0
DEFAULT TABLESPACE "CESHI01_DATA"
DEFAULT INDEX TABLESPACE "CESHI02_INDEX";
GRANT "PUBLIC","RESOURCE","SOI","SVI","VTI" TO "CESHI";
ALTER USER CESHI LIMIT FAILED_LOGIN_ATTEMPS UNLIMITED;
ALTER USER CESHI LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER USER CESHI LIMIT PASSWORD_LOCK_TIME UNLIMITED;