创建用户
create user hr IDENTIFIED by Dameng123 DEFAULT TABLESPACE TBSTEST;

密码策略
alter SYSTEM set 'PWD_POLICY' = 15 BOTH;

用户锁定和解锁
alter user hr ACCOUNT UNLOCK;
alter user hr ACCOUNT LOCK;

修改用户的默认表空间：
alter user hr DEFAULT TABLESPACE dmtbs;

修改用户密码:
alter user hr IDENTIFIED by "Dameng@123";
删除用户：
drop user if EXISTS hr;
drop user if EXISTS hr CASCADE; --生产环境慎用

查看当前用户拥有的权限:
select * from session_privs;
权限管理：
grant create table to hr;
grant select any table to hr; ##可能需要开启参数alter SYSTEM set 'ENABLE_DDL_ANY_PRIV' = 1 both;
赋予查询对象权限，精确到列
grant select (employee_id, employee_name) on dmhr.employee to hrtest;
revoke select on dmhr.employee from hr;

权限相关数据字典：
select * from dba_sys_privs t where t.GRANTEE= 'HRTEST';
select * from dba_role_privs t where t.GRANTEE= 'HRTEST';
select * from dba_tab_privs t where t.GRANTEE= 'HRTEST';

达梦社区地址 https://eco.dameng.com