Email Specific User Specific Data

Question & Answer
,
2

Hello @sree

Welcome to the community! Thanks for your question!

You can use Row-Level Security (RLS) in Amazon QuickSight to restrict data access based on the assignee.

By setting up RLS, you can ensure that users only receive data relevant to them, enhancing security and data privacy.

Prepare Your Data for RLS:

  • Ensure your dataset includes a column that identifies users, such as Assignee.
    Create a Permissions Table:

Create a Permissions Table:

  • Create a separate table that maps users to the rows they should have access to. This table should include columns for User and Assignee.

Example:

User Assignee
user1@example.com XYZ
user2@example.com SEE

Upload the Permissions Table to QuickSight:

  • Go to QuickSight and choose Manage data.
  • Click New dataset and upload your permissions table.

Set Up Row-Level Security:

  • Go to the dataset for which you want to set up RLS.
  • Click on Permissions and select Row-level security.
  • Choose the permissions table you uploaded.
  • Map the columns from your main dataset and permissions table. For example, map the Assignee column in your main dataset to the Assignee column in the permissions table, and map the User column in your permissions table to the Username field.
1 Like