Monday, June 29, 2015

DB Table Grants


For each table under DB schema must be next granting clause, so in USER can access and modify data inside that table:

 

GRANT SELECT ON <TABLE_NAME> TO QUERY_ROLE;

 

GRANT DELETE, INSERT, SELECT, UPDATE ON < TABLE_NAME> TO UPDATE_ROLE;

 

Friday, June 12, 2015

Error itms-90035 - Xcode

I have developed an Objective C application which is running absolutely fine on iPhone. Now, I want to submit the app to the App Store. Following is the steps to submit the app:
  1. Open Xcode and archive the project
  2. Click on validate (which is successful)
  3. Click on Submit to App Store
enter image description here

Solution:
remove .sh files from target.
The problem appears to be due to including files named "upload-dsym.sh" or other "*.sh" in the app bundle. Here are the steps to get past this error: 
Go to the project settings in Xcode and select the "Target" app icon
Select the Build Phases tab and click on "Copy Bundle Resources"
Look for files named "upload-dsym.sh" or other "*.sh"
Remove those files
Upload fine