oracle给role授权create view 后，仍然权限不足

create role r;
grant connect, resource, select any table, create view to r;
grant r to u;

u 在create table 时候，仍然报没权限

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-VIEW.html#GUID-61D2D2B4-DACC-4C7C-89EB-7E50D9594D30

The owner of the schema containing the view must have the privileges necessary to either select (READ or SELECT privilege), insert, update, or delete rows from all the tables or views on which the view is based. The owner must be granted these privileges directly, rather than through a role.

需要 显式 授权select table的权限给用户

grant select any table to u;