I guess he meant to create a view of a table with “where” conditions depend on your user privileges
For all i know there could be other methods in mysql at this point, but views is how people have been doing fine grained row permissions in mysql for decades.