4 ms·
You can allow predefined SQL strings and define security rules for each string. If you need new query, you have to write new security rule for it. Won't work fo
by vbezhenar 10y ago
You can allow predefined SQL strings and define security rules for each string. If you need new query, you have to write new security rule for it. Won't work for dynamically generated SQL, but for most CRUD SQL it should work.
- dkersten 10y agoIf you have N predefined SQL queries, then why not just wrap them in REST endpoints (it sounded to me that untog was suggesting that SQL be the interface to the data). If the user can write whatever query they want, then validating by string isn't really a good idea...