Re: Individual field rights in the same table
Posted by:
T Kapp
Date: April 17, 2024 06:42AM
Hi Barry,
I think I understand and will try the
[GRANT SELECT (col1), INSERT (col1, col2) ON mydb.mytbl TO 'someuser'@'somehost';] first.
Can I do this command from inside Workbench or does it have to be done in MySql?
Once again, thank you so much! I can't tell you how hard this has been for me. I've been using Paradox for the past thirty years to do work orders, formulas etc for our company. Problem was, it was too good of an application, and unlike access, didn't need constant updates.
Granting user permissions was just part of the table creation and only took minutes.
Thanks again.