达梦数据库常用命令

创建数据库和用户

create tablespace TBS_SAAS_AGRIWE datafile '/data/dmdata/DAMENG/TBS_SAAS_AGRIWE.DBF' SIZE 1024 AUTOEXTEND ON NEXT 1024;
CREATE USER "SAAS_AGRIWE" IDENTIFIED BY "Wesj#274Lo" DEFAULT TABLESPACE "TBS_SAAS_AGRIWE" DEFAULT INDEX TABLESPACE "TBS_SAAS_AGRIWE";
GRANT "PUBLIC","RESOURCE","VTI" TO "SAAS_AGRIWE";