Row level security

[prajaktakeni11]

Since i dont have emloyee email data how can I do row level security based on the employee id noton the emloyee email address 
any direction for me ?

[ChiragGarg2512]

@prajaktakeni11 , So, either create as many roles as there are employees[Advised not to] or add another column to the employee ID table that holds employee email. Otherwise there is no way of connecting employees to the role.

[ChiragGarg2512]

@prajaktakeni11 , Assignment to the role is done with the help of user email and cannot be done by employee ID. In a way access is shared to those emailID for a particular role. For example, a role 'Viewer' is assigned to some people, this can only be acessed by people with the emailID of those users.

[prajaktakeni11]

Hi @ChiragGarg2512 ,
Thank you for you reply... but i dont have email address in my table so can you please let me know workaround to this ?

[ChiragGarg2512]

@prajaktakeni11 when you ask for rls for do you mean to apply rls on employee ID or to give access to a role using employeeID?

[prajaktakeni11]

@ChiragGarg2512  I want to apply RLS on Employee ID

[ChiragGarg2512]

@prajaktakeni11 So if a role is made, the person for the role can see data matching only his employee ID, Correct?

[prajaktakeni11]

Yes @ChiragGarg2512