superset赋予某个角色只能查看已发布的dashboard权限，无编辑权限

最新推荐文章于 2024-07-25 19:58:57 发布

Lancer_Wu

最新推荐文章于 2024-07-25 19:58:57 发布

阅读量3.9k

点赞数 2

本文链接：https://blog.youkuaiyun.com/weixin_39358657/article/details/104469759

版权

本文介绍了如何在Superset中为特定角色设置权限，使其只能查看已发布的dashboard，而无法进行编辑操作。通过SQL插入数据表实现这一目标，确保用户登录后无法新建或修改dashboard，但仍能导出CSV数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

superset给某个角色赋予可编辑和操作权限比较简单，直接给用户赋予alpha角色就行，但是要只让新用户只有查看已公开发布的dashboard的权限，可就不太容易了，以下是我不断试出的权限搭配，直接使用sql插入数据表就行。

-- 先删除要给予只看dashbord角色的之前所有权限，7是我这边要赋予权限的role_id，可以从 ab_role 表中看到角色的id
delete from `ab_permission_view_role` where role_id = '7';
-- 给角色插入新的权限，可以将7替换为你要赋予的角色ID
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('50', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('52', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('112', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('51', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('53', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('72', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('73', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('74', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('79', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('85', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('91', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('100', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('105', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('115', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('126', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('133', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('147', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('156', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('228', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('235', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('242', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('248', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('255', '7');
INSERT INTO `ab_permission_view_role` (`permission_view_id`, `role_id`) VALUES ('264', '7');
INSERT INTO `

最低0.47元/天解锁文章