Re: Application Express access to a schema
Date: Tue, 31 Mar 2009 21:47:45 +0200
Create a new schema, and grant that schema only select access on objects of your existing schema. Maybe also create synonyms. Then use this new schema as the "parsing schema" in your application/workspace.
On Tue, Mar 31, 2009 at 9:31 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>wrote:
> Is it possible to setup Application Express so that it only has select
> access to a schema. I am thinking in regards to the E-Business suite where
> select would be permitted but no updates.
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
-- Toon Koppelaars RuleGen BV +31-615907269 Toon.Koppelaars_at_RuleGen.com www.RuleGen.com thehelsinkideclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.RuleGen.com/pls/apex/f?p=14265:13 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 31 2009 - 14:47:45 CDT