Introduces how to implement row-level security (RLS) in RisingWave by using logical views and access control.
employees
table to store employee data:
employees
table:
hr_manager
, engineering_manager
, and ceo
.
hr_manager
to ensure that they can only query the hr_employee_view
and cannot access the employees
table or other views.
Connect as hr_manager
and test access: