Devart Forums

Hi,

I have some users that don't want them to be able to update specific fields in a table. I have given MySQL restrictions on certain table fields for these users, so that my application raises an exception whenever a user tries to change these protected fields.
Is there however, any way that MyDAC will check for update access on these fields and react accordingly, not letting the user change the field - before sending the update query to the database?
Or, can I check programmatically for the access restrictions for the current user and be able to mark the field readonly at runtime so that the user is not able to change the - for example - checkbox?

Thanx in advance,
Kostas

MyDAC does not support such fuctionality. Try to implement it using MySQL server facility.

I think you must create user with differents actions:
Read, Write, Read-Write, Exe
RWX

Ok, I found that I can easily search the information_schema DB for the info that is needed to implement read-only fields inside the application.

Thanx anyway