Problem
User cannot access data from an EXTERNAL view without permissions on the underlying table
Answer
This is expected behavior as Okera does not manage the permissions on external data. To grant access to a view without access to the underlying table, drop and recreate the view as internal (CREATE VIEW view_name...)
Check the planner log for specific errors and ensure user has required GRANTs.
Comments
0 comments
Please sign in to leave a comment.