My team and I have been using Toad DP to query our SalesForce database for a while now, but we are interested in writing to the SalesForce db. Is this at all possible in Toad?
I am not a Salesforce developer-like user myself nor do i have direct access to verify it - i was able to find the following:
SELECT Id, SObjectType, PermissionsRead, Parent.label, Parent.IsOwnedByProfile FROM ObjectPermissions WHERE (ParentId IN (SELECT PermissionSetId FROM PermissionSetAssignment WHERE Assignee.Name = 'John Doe')) AND (PermissionsRead = true) AND (SobjectType = 'Account')
I believe the above code can be executed to determine permissions for a specific salesforce object type (i.e. Account, Opportunity…). I hope someone else can confirm whether only selecting data is allowed from TDP or also any other advanced stuff i found on the internet.