I need to create a report showing all the accounts that a concrete user has access to (it's a similar issue like the reported on Generate report for Account User access?)

I've tried to use the UserRecordAccess object (here is the spec) to query this information, but I've faced 2 important limitations for this object:

  • RecordId MUST be on where clause
  • just 200 records can be queried

Getting the list of all users and accounts and query them in chunks is not a viable solution (we are managing about 250.000 accounts, the governor limits for querying objects are a serius issue here)

Does anybody know other way of getting this information?

Thanks in advance

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.