人大金仓模式默认选中问题

https://blog.csdn.net/weixin_44789861/article/details/117854621

 

create user glib password 'cloudscape';
create role glib;
alter user system password 'cloudscape';

 

ALTER SCHEMA "fx" OWNER TO "username";

 

查看当前模式

select current_schema;

修改角色的搜索路径

alter role finona set search_path='finance';

创建用户专享的schema

CREATE SCHEMA sharedschema AUTHORIZATION scarlett;

用户模式权限

grant all on all tables in schema "CLOUDSCAPE_GLIB" to cloudscape_glib;

 

//查询连接情况 select datname,pid,application_name,state from pg_stat_activity;

//释放空闲连接  select pg_terminate_backend(1472) from pg_stat_activity where state='idle';

 

知识点：https://blog.csdn.net/weixin_41551276/article/details/119648172