ERROR: permission denied for relation <relation>
Article ID: 296786
Updated On:
Products
VMware Tanzu Greenplum
Issue/Introduction
"Permission denied" error is returned when selecting from a table or view:
gpooo1=# select * from ret_mkt_dm.cp_fr_contract_customer_vw limit 1; ERROR: permission denied for relation cp_fr_contract_vw
Environment
Product Version: 6.19
Resolution
Check:
+ The current_user logged in has SELECT access to the table or view referenced in the "SELECT" query..
+ If the relation is a view check that the owner of the view has .access to all the relations referenced in the view.
The owner of the view or tables has GRANT access to the schema that any table or view you are using.
+ The current_user logged in has SELECT access to the table or view referenced in the "SELECT" query..
+ If the relation is a view check that the owner of the view has .access to all the relations referenced in the view.
The owner of the view or tables has GRANT access to the schema that any table or view you are using.
Feedback
Yes
No
Powered by
