Mass Change to Access Rights

Hello, we have about 55,000 cases and since go-live the "manage by records" default read rights has given the all portal users sys admin object access to read all new cases. 

We would like to remove all portal users read rights to all the current cases. What is the best way to do this? I've tried to use a business process, however it errors out after processing 2000 records. Is there a SQL query that can be used?



I was able to solve this with this SQL query in the SQL console marketplace app: delete from syscaseright where sysadminunitid = ‘(id of portal user)'



Hi Mitch, there was a BPM Online provided add on to handle such mass access control editing ..… i used this in once implementation, really a handy one..


Thank you! sounds very helpful!

Log in or register to comment