I want to enable row-level security for a integer column, when I was trying for tag based rules, it is showing only String columns. Please let mw know how can we enable rls here. If it is user based rules, kindly provide a sample permission file

Question & Answer
,
1

I want to enable row-level security for a integer column, when I was trying for tag based rules, it is showing only String columns. Please let mw know how can we enable rls here. If it is user based rules, kindly provide a sample permission file

2

Hi @khalidaparveen,

You can’t use RLS with integer columns. You’ll have to change the integer columns to string. If you need them as integers because of the type of calculations they are used in, I would suggest creating separate string columns for RLS purposes while keeping the original integer columns for calculations.

1 Like
3

If we want to enable it for integer columns(eg: based on user id), please let us know how can we follow. If we need to follow user based rules, can you please provide sample permissions file that we can use

4

Hi @khalidaparveen - As suggested by David, you can not put a RLS on integer, either you need to cast or create a new field from integer and cast it string and use the new field for your RLS. See the documentation below.

Using row-level security with user-based rules to restrict access to a dataset - Amazon QuickSight.

Regards - Sanjeeb

5

Hi @khalidaparveen,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!