为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【是否存算分离】
【StarRocks版本】例如：2.5.13
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
执行查询sql时，用户没有某一张表的权限，但是sql可以执行，具体sql如下：
SELECT DATE_FORMAT(now(), ‘%Y-%m-%d’),101604, 1, 3, now(), bitmap_and (( SELECT ifnull( bitmap_union (to_bitmap(accountid)), bitmap_empty ()) FROM qcwy_ods.ods_accountid_event_status_rt ), bitmap_and (( SELECT ifnull( bitmap_union (to_bitmap(accountid)), bitmap_empty ()) FROM qcwy_ods.ods_accountid_event_status_rt WHERE pt = DATE_FORMAT(now(), ‘%Y-%m-%d’) AND EVENT IN (‘pushcallback’, ‘click’)), ( SELECT ifnull( bitmap_union (to_bitmap(accountid)), bitmap_empty ()) FROM qcwy_ods.ods_accountid_event_status_rt WHERE pt = DATE_FORMAT(now(), ‘%Y-%m-%d’) AND EVENT = ‘LoginRegistResult’ ))) una;
执行查询结果如下：
查询用户权限如下：
SQL语句改写为临时表方式时，会报权限异常
‘test’@(none) 16:20:02> WITH t2 AS ( SELECT bitmap_union (account_id_union) account_id_union FROM dwm.marketing_group WHERE dd = DATE_FORMAT(now(), ‘%Y-%m-%d’) AND group_id = 3084 AND version = ( SELECT ifnull(max(version), 0) AS version FROM dwm.marketing_group WHERE dd = DATE_FORMAT(now(), ‘%Y-%m-%d’) AND group_id = 3084 )), t3 AS ( SELECT ifnull( bitmap_union (to_bitmap(accountid)), bitmap_empty ()) anr FROM qcwy_ods.ods_accountid_event_status_rt WHERE pt = DATE_FORMAT(now(), ‘%Y-%m-%d’) AND EVENT IN (‘pushcallback’, ‘click’)), t4 AS ( SELECT ifnull( bitmap_union (to_bitmap(accountid)), bitmap_empty ()) anr FROM qcwy_ods.ods_accountid_event_status_rt WHERE pt = DATE_FORMAT(now(), ‘%Y-%m-%d’) AND EVENT = ‘LoginRegistResult’ ) SELECT DATE_FORMAT(now(), ‘%Y-%m-%d’), 101604, 1, 3, now(), 3084, bitmap_and (( SELECT account_id_union FROM t2 ), bitmap_and ((SELECT anr FROM t3), (SELECT anr FROM t4))) una
-> ;
ERROR 1064 (HY000): SELECT command denied to user ‘test’@‘10.100.1.10’ for table ‘Table [id=28813746, name=ods_accountid_event_status_rt, type=OLAP]’