In Editor php libraries, how to enforce the where clauses to edits?

In Editor php libraries, how to enforce the where clauses to edits?

CanDoITCanDoIT Posts: 1Questions: 1Answers: 0

Hi,

The table is shared to all my users, and there is a "club" column which I use in the where clause to only display the rows that my user should have access to.

That works fine to display the table, but I can, by manually changing the row_ID values (client side), update data from rows the user should not have access to.

Ho can I prevent that?

Answers

  • allanallan Posts: 63,791Questions: 1Answers: 10,513 Site admin

    You would need a custom validator on the server-side. Basically you would use the validator to ensure that the user has the correct level of access to be able to write to the row.

    That will likely need a database call, and you can use the Database class in Editor to do that.

    Allan

This discussion has been closed.