function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Edward RossEdward Ross 

Exporting Sharing Settings / Organization-Wide Defaults

We need to export the Sharing Settings / Organization-Wide Defaults - to indicate whether each table has the public or private sharing mode.  Does anyone know how this can be done with the APIs?

 

I looked at the Organization object in the SOAP API:

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_organization.htm

But this doesn't say whether each object has public or private sharing enabled.

 

I looked in the meta data API but it says here:

http://www.salesforce.com/us/developer/docs/api_meta/index.htm

that organization wide defaults are not accessible through the meta-data API.

 

Thanks,

 

Edward.

Jerome RussJerome Russ
You can use the following query:
Select id, Parent.Profile.Name, sObjectType, PermissionsCreate, PermissionsDelete, PermissionsEdit, PermissionsRead, PermissionsModifyAllRecords,  PermissionsViewAllRecords 
from ObjectPermissions

The easiest way to do this would be to go to https://workbench.developerforce.com/login.php and run the query there.