Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2022 06:58 AM
If the owners are not the same, the user (one which has SELECT on VIEW) must also have SELECT privileges on the underlying table.
Please check that owner of the view and table are the same. If not, please set it to the same owner (user or group).
ALTER SCHEMA <schema-name> OWNER TO `<user-name>@<user-domain>.com`
My blog: https://databrickster.medium.com/