Quick BI中查看仪表板的报表时,报错：“ODPS-0130013:Authorization exception - Authorization Failed [4031], You have NO privilege 'odps:Select' on{XXXXXX}”
问题描述
Quick BI中查看仪表板的报表时，报错：
NTERNAL: java.sql.SQLException: java.util.concurrent.ExecutionException: java.sql.SQLException: execute sql [XXXXXX,XXXXXXX;] instance:[20211201071944847gxwkz4zm] failed: ODPS-0130013:Authorization exception - Authorization Failed [4031], You have NO privilege 'odps:Select' on {acs:odps:*:projects/XXXXXXX}. CheckLabelSecurity failed. The sensitive label of column 'book_date_month' is 2, but your effective label is 0. CheckLabelSecurity through package failed. Context ID:029dea82-1100-4d69-8ad4-248812182bf0. --->Tips: Pricipal:RAM$fliggymarriott:xiaoyue; Your LABEL is not enough to access column: book_date_month,book_year,orders,ds
解决方案
ODPS数据源底层数据表的owner没有select权限,需要重新申请一下select权限即可。
适用于
- Quick BI
- 仪表板