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
1009
April 12, 2024 10:20AM
476
April 14, 2024 07:47AM
Re: Individual field rights in the same table
400
April 14, 2024 08:02PM
474
April 15, 2024 08:43AM
448
April 15, 2024 08:34PM
457
April 16, 2024 09:33AM
435
April 16, 2024 04:32PM
343
April 17, 2024 06:42AM
374
April 17, 2024 04:02PM
356
April 19, 2024 11:52AM
449
April 22, 2024 09:04AM
379
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.