Predicated Privileges

With predicated privileges, the table owner provides row-level access to users, groups or roles by specifying a SQL where on the grant statement. You use the full power of SQL, including access to other tables, to implement a comprehensive row-level security policy. See “Granting Predicated Privileges”.