I want to set permissions that are not in the default.
The default expression is:
SWITCH(USEREMAIL(),
โuser1@mydomain.comโ, โUPDATES_ONLYโ,
โuser2@mydomain.comโ, โALL_CHANGESโ,
โREAD_ONLYโ)
โAdd and updateโ
โALL_CHANGESโ allows it to be deleted, so I donโt want it to be deleted.
I'm sorry if it's hard to understand because I'm typing after translating Japanese.
Thank you for your support.
Solved! Go to Solution.
The default expression is just an example you can build your own expression using any of the desired options. The available options are as below
"READ_ONLY", "UPDATES_ONLY", "ADDS_ONLY", "ADDS_AND_UPDATES", "DELETES_ONLY", "UPDATES_AND_DELETES", "ADDS_AND_DELETES", and "ALL_CHANGES"
So if you wish to disallow delete operations on the table, you could use options such as "READ_ONLY", "UPDATES_ONLY", "ADDS_ONLY", "ADDS_AND_UPDATES"
So you could have an expression something like
SWITCH(USEREMAIL(),
โuser1@mydomain.comโ, โUPDATES_ONLYโ,
โuser2@mydomain.comโ,"ADDS_AND_UPDATES",
โREAD_ONLYโ)
Again the above is an example. Please fine tune it based on your real requirements.
The default expression is just an example you can build your own expression using any of the desired options. The available options are as below
"READ_ONLY", "UPDATES_ONLY", "ADDS_ONLY", "ADDS_AND_UPDATES", "DELETES_ONLY", "UPDATES_AND_DELETES", "ADDS_AND_DELETES", and "ALL_CHANGES"
So if you wish to disallow delete operations on the table, you could use options such as "READ_ONLY", "UPDATES_ONLY", "ADDS_ONLY", "ADDS_AND_UPDATES"
So you could have an expression something like
SWITCH(USEREMAIL(),
โuser1@mydomain.comโ, โUPDATES_ONLYโ,
โuser2@mydomain.comโ,"ADDS_AND_UPDATES",
โREAD_ONLYโ)
Again the above is an example. Please fine tune it based on your real requirements.
ใใใใจใใใใใพใใ
ๅคงๅคๅฉใใใพใใใ
ใฉใใใใใพใใฆ
User | Count |
---|---|
43 | |
30 | |
27 | |
14 | |
14 |