kingbase 修改search_path

使普通用户可以查询别的用户的表而前面不加模式

一.数据库级别

1. alter database jxfgw set search_path=jxfgw,"$USER", PUBLIC; 前后不要加’单引号

2. select sys_reload_conf();

3. grant USAGE ON SCHEMA jxfgw to aa;  记得模式给权限

4. alter database reset search_path; 恢复默认设置

二：推荐用户级别更改，影响范围小

1. alter user zyf set search_path =jxfgw,"$USER", PUBLIC; 

2.select sys_reload_conf();

3.grant USAGE ON SCHEMA jxfgw to zyf;

4.alter user zyf reset search_path;恢复默认设置