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
755
April 12, 2024 10:20AM
332
April 14, 2024 07:47AM
Re: Individual field rights in the same table
285
April 14, 2024 08:02PM
305
April 15, 2024 08:43AM
343
April 15, 2024 08:34PM
358
April 16, 2024 09:33AM
291
April 16, 2024 04:32PM
238
April 17, 2024 06:42AM
274
April 17, 2024 04:02PM
246
April 19, 2024 11:52AM
344
April 22, 2024 09:04AM
258
April 22, 2024 01:04PM
Sorry, you can't reply to this topic. It has been closed.
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.