达梦8数据库用户、权限、角色介绍

用户：

1.创建表空间

create tablespace "DM" datafile '/dm8/dmdata/DAMENG/DM01.DBF' size 500 autoextend on maxsize 67108863, '/dm8/dmdata/DAMENG/DM02.DBF' size 500 autoextend on maxsize 67108863 CACHE = NORMAL;

2.删除表空间

drop tablespace "DM";

3.扩容表空间

alter tablespace DM resize datafile '/dm8/dmdata/DAMENG/DM01.DBF' to 600;

4.创建用户指定表空间

 create user dm identified by "dm@123456" default tablespace DM;

5.修改用户密码

alter user dm identified by DMdm123456;

6.用户空间限制

 ALTER USER DM DISKSPACE LIMIT 50;

7.用户空间无限制

 ALTER USER DM DISKSPACE UNLIMITED;

8.用户状态锁定

 alter user DM account lock;

9.用户解锁

alter user DM account unlock;

角色：

1.查看当前角色

select * from dba_role_privs where grantee='DM';

GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE
------- ------------