This content has been marked as final. Show 5 replies
Oracle Sales directed me to this forum for technical questions. I guess they think that someone from Oracle is answering questions here. Is my question too complex?
The Oracle Database Cloud Service can provide some but not all of the features you require.
The ability to create 2 schema usersNot possible, each cloud service has access to just one schema.
The ability to grant permissions between the schema ownersYou cannot grant permissions, see above.
The ability to create synonyms (private is ok)You cannot create synonyms.
The ability for the dad to be set to Custom OWA so it calls myschema.owa_custom.authroize() at each page requestYou cannot create a callback owa_custom.authorize. However, you have OUATH2 authentication which will allow you to create your own security based on the user id for each request.
The ability to create a procedure my hello_world procedure (below)You can create procedures which generate HTML using the htp package. You also have access to the OWA pakages.
The ability to access the procedure via a urlYou can access the procedure via a url using a RESTful web service with PL/SQL source type. See this document (http://www.oracle.com/technetwork/database/database-cloud/public/restful-wp-1844130.pdf) for more details.
500k-1MM page hits per dayThe hits per day is not a problem, the maximum data transfer is controlled by the level of service you purchase.
Thank you Rod for following up.
Does Oracle offer any other type of hosting where I could have more flexibility inside of the database and also have a web server running apache / mod_plsql?
Edited by: brian.mcginity on Jan 31, 2013 12:08 PM
You might want to investigate Oracle Managed Cloud Services, formerly known as Oracle OnDemand. Thanks for your interest.
- Rick Greenwald