达梦数据库创建表空间和用户

CREATE TABLESPACE GDXF DATAFILE
'D:2DATAbaseDMDBMSDATADAMENGGSXF_01.DBF' SIZE 128 AUTOEXTEND ON NEXT 40 MAXSIZE  10240, 
'D:2DATAbaseDMDBMSDATADAMENGGSXF_02.DBF' SIZE 128 AUTOEXTEND ON NEXT 40 MAXSIZE  10240;
--创建普通用户
CREATE USER GDXF IDENTIFIED BY "GDXFGDXFGDXF"  DEFAULT TABLESPACE GDXF;
--赋予普通用户权限
GRANT "RESOURCE","PUBLIC","DBA","VTI" TO GDXF;
--修改数据库用户密码7天过期：
ALTER USER GDXF LIMIT PASSWORD_LIFE_TIME UNLIMITED;
--修改用户口令过期时间限制：
ALTER  USER  GDXF  LIMIT  FAILED_LOGIN_ATTEMPS  UNLIMITED;
--修改用户失败登录次数限制：
ALTER  USER  GDXF LIMIT  PASSWORD_LIFE_TIME  UNLIMITED;
--修改用户口令锁定限制：
ALTER  USER GDXF LIMIT  PASSWORD_LOCK_TIME  UNLIMITED;

--查询表空间
 select * from v$tablespace;
--查询数据文件
select * from v$datafile;

select
        t.name tablespace_name,
        d.free_size*SF_GET_PAGE_SIZE()/1024/1024
        ||'M' free_space,
        d.total_size*SF_GET_PAGE_SIZE()/1024/1024
        ||'M' total_space,
        d.free_size*100/d.total_size||'%' "% FREE"
from
        v$tablespace t,
        v$datafile d
where
        t.id=d.group_id;