测试:
create schema s1;
create table s1.t1(c1 int,c2 int,c3 int);
grant USAGE on SCHEMA s1 to ud;
create view s1.v2 as select a.c1,a.c2,a.c3 from s1.t1 a;
grant SELECT on s1.v2 to ud;
\c - ud
--此时ud账户可以查询s1.v2
alter view v2 rename to v3 ;
修改s1.v1视图重命名,ud账户查询失败,提示权限问题,
需要重新grant select 才可以登录ud用户查询该视图。