9 ms·
Curious, Is there an easy way to do row-level and field-level security in MySQL?
by santa_boy 1y ago
Curious, Is there an easy way to do row-level and field-level security in MySQL?
- bawolff 1y agoViews?
- user32489318 1y agoI guess he meant to create a view of a table with “where” conditions depend on your user privileges
- bawolff 1y agoYes, using the DEFINER clause. 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.
- fipar 1y agoField-level is just column privileges. Row-level, I think you can only achieve that with views, which is less than ideal.