达梦建表空间和用户达梦建表空间和用户

达梦建表空间和用户

创建表空间

create tablespace ricisso datafile 'ricisso.dbf' size 100 autoextend on maxsize 500;

创建用户

create user uricisso identified by uricisso123 default tablespace ricisso;

给用户授权

grant resource,public to uricisso;

创建模式

create schema test111 authorization uricisso;