Re: Application Express access to a schema

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-l