Help Center/ Data Lake Insight/ FAQs/ Permission/ O&M Guide/ Why Can't I Query a View After I'm Granted the Select Table Permission on the View?
Updated on 2023-05-19 GMT+08:00

Why Can't I Query a View After I'm Granted the Select Table Permission on the View?

Symptom

User A created Table1.

User B created View1 based on Table1.

After the Select Table permission on Table1 is granted to user C, user C fails to query View1.

Possible Causes

User B does not have the Select Table permission on Table1.

Solution

Grant the Select Table permission on Table1 to user B. Then, query View1 as user C again.