国产关系型数据库达梦8创建用户

创建表空间

-- 创建表空间
create tablespace "TBS_MYUSER" datafile 'TBS_MYUSER_01.DBF' size 1024 autoextend on next 1024, 'TBS_MYUSER_02.DBF' size 1024 autoextend on next 1024, 'TBS_MYUSER_03.DBF' size 1024 autoextend on next 1024;
-- 创建索引表空间
create tablespace "IDX_MYUSER" datafile 'IDX_MYUSER_01.DBF' size 1024 autoextend on next 1024, 'IDX_MYUSER_02.DBF' size 1024 autoextend on next 1024, 'IDX_MYUSER_03.DBF' size 1024 autoextend on next 1024;

创建用户

-- 创建用户
create user "MYUSER" identified by "123456YP" default tablespace "TBS_MYUSER" default index tablespace "IDX_MYUSER";
-- 授权
grant "PUBLIC","RESOURCE","SOI","VTI" to "MYUSER";
-- 取消用户资源使用限制
alter user "MYUSER" limit failed_login_attemps unlimited, password_lock_time unlimited, password_grace_time unlimited;

终端登录

su - dmdba
/data/dmdbms/bin/disql MYUSER/'"123456YP"'@IP:PORT