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
393
April 12, 2024 10:20AM
148
April 14, 2024 07:47AM
Re: Individual field rights in the same table
126
April 14, 2024 08:02PM
120
April 15, 2024 08:43AM
170
April 15, 2024 08:34PM
179
April 16, 2024 09:33AM
123
April 16, 2024 04:32PM
95
April 17, 2024 06:42AM
130
April 17, 2024 04:02PM
95
April 19, 2024 11:52AM
159
April 22, 2024 09:04AM
99
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.