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;

 

--查询所有用户的权限
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

 

--如果授权 test用户只有  select 权限,需要revoke其它权限
grant  select  any table to  test ;
revoke  以上权限  any table from test;

 

done