1、修改参数

2、创建两个用户

create
user a1 connection limit-1 password '123456';

alter user a1 SUPERUSER;

grant create
on
database "test" to "a1" with grant option;

grant temporary on
database "test" to "a1" with grant option;

grant temp on
database "test" to "a1" with grant option;

grant connect on
database "test" to "a1" with grant option;

create
user a2 connection limit-1 password '123456';

alter user a2 SUPERUSER;

grant create
on
database "test" to "a2" with grant option;

grant temporary on
database "test" to "a2" with grant option;

grant temp on
database "test" to "a2" with grant option;

grant connect on
database "test" to "a2" with grant option;

create schema a1schema;

create table a1schema.t1(id int);

create schema a2schema;

create table a2schema.t2(id int);

insert into a2schema.t2 values(111111111);

CREATE VIEW "a1".v_t2 AS select id from a2.t2;

create synonym t2 for v_t2;

selet * from t2