if my main table have a security filter (only my own rows are visible) i need yet to add security filters to my other 10 tables if its part of the main table?
sample:
table event ( id_eventโฆ)
table person (fk_event (ref - is part of event) โฆ)
table object (fk_event (ref - is part of event) โฆ)
โฆ โฆ
i need to protect the access to tables person and object or the appsheet system already to do it automatically?
thanks!
Yes, you will need security filters for all tables - I donโt believe you can do it any other way.
Ok, thanks @Bellave_Jayaram
A security filter applies only to the table for which itโs defined; there is no automatic protection for related tables.
Beware, though: security filters can create a mess very quickly if you arenโt very careful with both your filter and your data design. A big one: your app wonโt be aware of the data thatโs been filtered, so itโs possible to create a duplicate key!
Security filters are best used to prevent sensitive data from ever reaching the userโs device. Itโs still possible to hide data that does reach the device from the user without security filters, and with fewer potential complications.
I was thinking too about scalability, if i a have 100 users and each them have 30 rows of each tableโฆso is so better receive only my 30 rows of each table than receive 3000 rows for each!
True. Iโve used security filters myself for just that very concern.
A security filter is best used in this case on tables with rows that can be clearly associated with only a single user and there will be no need for multiple users to access each otherโs rows.
When creating keys in a table with a security filter, be sure to use UNIQUEID().
If you have other columns that are supposed to have unique values, keep in mind that whatever expressions you use to enforce uniqueness will only see the filtered data, not all data. It will not be possible to enforce uniqueness across all users using only filtered tables.
Of course +Steve Coileโฆin all of my tables I have used security filters or they are read only or they have a random number generated for their id!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |