Altibase 用户和权限管理

--建新用户ocs，密码ocs
create user ocs identified by ocs;

--查看密码
select * from SYSTEM_.SYS_USERS_;

--改用户密码
alter user ocs identified by ocs;

--删除用户test
drop user test cascade;

--授权
grant user test  XXX;

--查询所有用户的权限
select a.user_id,a.user_name,c.priv_name from system_.sys_users_ a
left join system_.sys_grant_system_ b on a.user_id=b.grantee_id
left join system_.sys_privileges_ c on b.priv_id = c.priv_id;

默认的用户权限，一般不用修改，默认就够用了
CREATE_PROCEDURE
CREATE_SEQUENCE
CREATE_SESSION
CREATE_TABLE
CREATE_VIEW
CREATE_TRIGGER
CREATE_SYNONYM

Altibase 用户和权限管理

原文：https://www.cnblogs.com/flash100/p/13999252.html