# Column level Security for a table

**URL:** <https://community.amazonquick.com/t/column-level-security-for-a-table/11788>\
**Category:** Q&A\
**Tags:** column-level-security, quick-sight\
**Created:** [April 3, 2023, 8:17am UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788 "2023-04-03T08:17:04Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![karthik.kumar](https://avatars.discourse-cdn.com/v4/letter/k/b77776/32.png) [@karthik.kumar](https://community.amazonquick.com/u/karthik.kumar)\
**Post date:** [April 3, 2023, 8:17am UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/1 "2023-04-03T08:17:04Z")

</div>

I have created a table which contains member details. when I add column level security for fields such as mobile number and email id. The users are unable to view the whole visual (not even other columns excluding mobile number and email id). I read somewhere that column level security can be applied for measure only. Is there any workaround for the above mentioned use-case?

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [April 3, 2023, 9:31am UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/2 "2023-04-03T09:31:30Z")

</div>

Hi @karthik.kumar - I saw the AWS documentation and not sure CLS is only applicable to measures only. See the below link and validate whether you have configured CLS properly or not.

> **[Using column-level security (CLS) to restrict access to a dataset - Amazon...](https://docs.aws.amazon.com/quicksight/latest/user/restrict-access-to-a-data-set-using-column-level-security.html)**
>
> Restrict access to an existing dataset by using column-level security (CLS) in Amazon QuickSight.

If the issue is still persists, please raise an AWS ticket ( link to raise a ticket- [Creating support cases and case management - AWS Support](https://docs.aws.amazon.com/awssupport/latest/user/case-management.html))  
. If you do not have access to raise a ticket, request your admin to help you on this.

Regards - San

---

<div class="post-metadata">

**Author:** ![karthik.kumar](https://avatars.discourse-cdn.com/v4/letter/k/b77776/32.png) [@karthik.kumar](https://community.amazonquick.com/u/karthik.kumar)\
**Post date:** [April 3, 2023, 10:03am UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/3 "2023-04-03T10:03:35Z")

</div>

Thanks for the reply San, As per the document it states " If a table or pivot table has restricted columns in the Values field well, you can see the table in an analysis or dashboard with only the values that you have access to. The values for restricted columns show as Not Authorized".  
Here I would like to apply CLS for mobile and email, These cannot be added in value field well. Is there a work around this?

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [April 3, 2023, 10:14am UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/4 "2023-04-03T10:14:40Z")

</div>

Hi @karthik.kumar - It should work for you. Can you follow the document and implement the CLS for a new data set and see the outcome. If it is not working, quick suggestion to raise a ticket and show your screen to AWS experts so that they will validate the configurations.

Tagging experts in this blog as well  
@Max @Bhasi_Mehta @Biswajit_1993 @Thomas @Tatyana_Yakushev @Kristin

Regards - San

---

<div class="post-metadata">

**Author:** ![karthik.kumar](https://avatars.discourse-cdn.com/v4/letter/k/b77776/32.png) [@karthik.kumar](https://community.amazonquick.com/u/karthik.kumar)\
**Post date:** [April 3, 2023, 10:18am UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/5 "2023-04-03T10:18:01Z")

</div>

Sure San. Will check that out. Quick question- Is this applicable only for the new datasets and not for the existing ones ?

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [April 3, 2023, 10:20am UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/6 "2023-04-03T10:20:34Z")

</div>

Hi @karthik.kumar - Create a new data set and try this out?

Regards - San

---

<div class="post-metadata">

**Author:** ![karthik.kumar](https://avatars.discourse-cdn.com/v4/letter/k/b77776/32.png) [@karthik.kumar](https://community.amazonquick.com/u/karthik.kumar)\
**Post date:** [April 13, 2023, 12:05pm UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/7 "2023-04-13T12:05:33Z")

</div>

This isnt working with new dataset as well. Correct me if I am doing it wrong, I have attached a screenshot for your reference .

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/9/9565585023ac987308689de442c81d35aba2f7db.png)

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [April 13, 2023, 4:58pm UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/8 "2023-04-13T16:58:35Z")

</div>

Hi @karthik.kumar - Can you please raise a ticket to AWS team so that they can validate your configuration of CLS and guide you.

Regards -San

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [May 8, 2023, 8:07pm UTC](https://community.amazonquick.com/t/column-level-security-for-a-table/11788/9 "2023-05-08T20:07:44Z")

</div>


