I'm searching for a way to update the access for a field in all roles at the same time.
Today when I create a new field the default access is set to 'Write' but in 99% of our roles I want the access to be 'Hide'.
I'm missing a 'Update all' function, but I'm convinced that someone has a nice SQL statement to do this.
It takes a lot of time to go through all roles every time I create a new field and this functionality should save me a lot of time.
Another question I have is if it's possible to have the access to be 'Hide' as default instead of 'Write'. I want to have the control of the access each role has, but now it's like give every one everything...
1. Does anyone have a sql script to update the access for a field in all roles at the same time ?
2. Is it possible to change the default access a field gets from 'Write' to 'Hide' ?
by default Service Desk grants write access to new fields, you need to manually go through each role and either hide the field or make it read only. Service Desk is full of good functionality like that ;-)
Regarding sql script to update the field for all roles, im sure it is possible but im not a sql expert.