GRANTOR GRANTEE TABLE_SCHEMA TABLE_NAME PRIVILEGE GRANTABLE HIERARCHY
A B A VW_A SELECT NO NO
GRANTOR GRANTEE TABLE_SCHEMA TABLE_NAME PRIVILEGE GRANTABLE HIERARCHY
C B C TAB_A SELECT NO NO
view A.VW_A is FROM from C.TAB_A
B can select C.TAB_A.
But B can not select A.VW_A
Why?
Is that I have to grant A.VW_A from C? or HIERARCHY means sth.?
Thanks