Row Level Security to provide access to data rather than restrict access

[DanYuncken]

Hi All,

I was wondering if there is a way using row level security and roles to grant access to information to rather than restricting access. More specifically, restrict all access to users that don’t have any roles OR not part of any allowed roles.

I want to manage who has access rather than who doesn’t.

Thanks in advance,

Dan

[v-yulgu-msft · Accepted solution]

Hi @DanYuncken,

In essence, configuring RLS is aimed to grant permission to specific users. We add users to corresponding roles, as a result, they are given access to specific information. If we don't add a user to any role, he cannot view any data in that report.

Regards,

Yuliana Gu

[DanYuncken]

Thanks for clarifying!