Looking to do a security audit of all user permissions. I think I can use the Salesforce PHPToolkit 11 API to generate the report but new to Salesforce and a little confused on where to start.
In Salesforce Setup Under:
Administration Setup -> Manage Users -> Profiles -> Profile Names
If you click on each user name you can see the permissions set and the actions the user is allowed to perform. Wanted a way to generate an excel report for all users with all the permissions for that user.
Example:
User Name | Can view Case | Can edit case | Can delete case | etc...
phill yes no no x...
and so on.
I see that in Salesforce I can run a high level report on the Profile but I need to drill down for each user.
Has anyone every done this type of reporting before?
You should just be able to run the query command with some soql to grab each user and join that user to their perms.
Check out the docs (http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_relationships.htm)