Forum Discussion
Row level security
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 ?
7 Replies
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.
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 ?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 , 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.
