Teradata复杂视图跨库访问权限问题

grant select,create view,drop view on madm_view to bat_madm;
grant select on gdm_view to bat_madm;
grant select on gdm_view to madm_view with grant option;

--创建目录结构
modify user citic_edw as perm=2E6;  
create database testdb from citic_edw as perm=2E6 spool=2E6;
create user testuser from citic_edw as spool=0 perm=0 password="testuser_123";
--创建数据库madm_view
create database madm_view from testdb as perm=1E6 spool=1E6;
--创建数据库gdm_view，以及所需表和视图
create database gdm_view from testdb as perm=1E6 spool=1E6;
create multiset table gdm_view. tbB , no fallback,no before journal,no after journal( a varchar(10))  no primary index;
replace view gdm_view.testB as locking row for access sel * from gdm_view. tbB;
--创建bat_madm用户，并赋予相应权限
create user bat_madm from testuser  as spool=0 perm=0 password="bat_madm_123";
grant select,create view,drop view on madm_view to bat_madm;
grant select on gdm_view to bat_madm;

--语句一（执行成功)：
replace view madm_view.testA as select * from gdm_view.testB; 
--语句二（执行成功)：
select * from gdm_view.testB;
--语句三（执行失败)：
select * from madm_view.testA;

grant select on gdm_view to madm_view with grant option;

--语句一（执行成功)：
replace view madm_view.testA as select * from gdm_view.testB; 
--语句二（执行成功)：
select * from gdm_view.testB;
--语句三（执行成功)：
select * from madm_view.testA;