Sheet level access for users

Question & Answer
,
1

I have one dashboard and it includes 4 sheets. Consider there are sheet1, sheet2, sheet3 and sheet4.
I have user1 and user2. I need user should only access sheet1 and sheet2 and user2 should only access sheet3 and sheet4.
But all the sheets are include in one dashboard, so could you anyone of you please clarify whether I am able to give the sheet-level access or not.

2

Hello Priyanka,

For Amazon QuickSight, here’s what you need to know about sheet-level access control:

Currently, QuickSight doesn’t support sheet-level permissions within a single dashboard. The permissions in QuickSight work at these levels:

  1. Dashboard Level
  2. Dataset Level
  3. Row-Level Security (RLS)
  4. Column-Level Security (CLS)

For your requirement, here are the possible solutions:

Best Solution:

  • Create two separate dashboards:
    • Dashboard A with sheet1 and sheet2 - share with user1
    • Dashboard B with sheet3 and sheet4 - share with user2
    • Use the “Share” feature in QuickSight to grant specific permissions

Alternative Approaches:

  1. Row-Level Security (RLS):
  • Implement RLS using user attributes or rules
  • Filter data based on user identity
  • Users might see all sheets but with filtered data
  1. Dataset Level Security:
  • Create separate datasets for different user groups
  • Apply appropriate permissions at the dataset level

Remember:

  • Dashboard sharing in QuickSight is all-or-nothing
  • You cannot restrict access to specific sheets within a dashboard
  • The most secure approach is to create separate dashboards for different user groups

Currently , the recommended approach would be to split your current dashboard into two separate ones to maintain proper access control.

This feature has also been requested. However, the ETA is unknown at the moment.

hope this helps.
Cheers,
Deep

1 Like
3

Got it @Deep thank you so much for giving the clarity.