Different data according logged user

Q&A
, ,
1

Hello all,
in our company we are using web aplication ERP system, to where we embed the QS reports.
Is there i a way to show specific data acording the user who logged into the system?
For example financial reports. People from cost center XXX cannot see data of cost center YYY.

Thank you

2

Hello Vasek,

Yes, you can implement row-level security (RLS) in Quick Sight to control data access based on the user who is logged in. Here are a few approaches:

  1. Using Quick Sight Row-Level Security:
  • Set up RLS rules in Quick Sight that map users to specific cost centers
  • Define permissions based on user attributes or groups
  • Users will only see data they’re authorized to access
  1. Through IAM Integration:
  • Use AWS IAM roles and policies to control access
  • Map IAM roles to specific Quick Sight users/groups
  • Define what data each role can access
  1. Using Dataset Filters:
  • Create user-based filters in your datasets
  • Filter data based on user parameters
  • Pass user context from your ERP system to Quick Sight

Implementation steps:

  1. Define security rules for your datasets
  2. Map users to their respective cost centers
  3. Create appropriate permission sets
  4. Test access controls to ensure proper data segregation

This way, when users access reports through your ERP system, they’ll only see data relevant to their cost center or permission level.

References to understand more:

  1. Row-Level Security (RLS) Documentation:
  1. Quick Sight Security Documentation:
  1. Embedding Quick Sight Dashboards:
  1. AWS Tutorials and Workshops:

Hope this helps.

Cheers,
Deep

1 Like