Re: Individual field rights in the same table
The Fine Manual describes privileges for MySQL.
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
My reading tells me you can define to a table (as well as other database objects) but not to field within a table.
You could define your "restricted" data as a VIEW and grant privilege to that object, and not the table the VIEW is taken from, if that suits you.
Good luck,
Barry.
Subject
Views
Written By
Posted
554
April 12, 2024 10:20AM
237
April 14, 2024 07:47AM
Re: Individual field rights in the same table
200
April 14, 2024 08:02PM
209
April 15, 2024 08:43AM
259
April 15, 2024 08:34PM
266
April 16, 2024 09:33AM
214
April 16, 2024 04:32PM
159
April 17, 2024 06:42AM
195
April 17, 2024 04:02PM
159
April 19, 2024 11:52AM
250
April 22, 2024 09:04AM
167
April 22, 2024 01:04PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.