(My LibreOffice Base connect to mysql Base via jdbc connector.)
I have a TABLE with COLUMN1, COLUMN2, COLUMN3.
A USER has full access to COLUMN1 and COLUMN2, but he shouldn’t have any access to COLUMN3.
So I create a “NEW FORM” in a LO Base with two fields (for COLUMN1 and COLUMN2). I thought that USER will be able to work with these columns, but USER can’t open NEW FORM cause of such error:
SQL Status: 42000
Error code: 1142
SELECT command denied to user ‘USER’ for table ‘TABLE’
So how can I resolve this problem: USER needs to work with first ans second column via NEW FORM, but he shouldn’t have any access to third form.