Re: Application Express access to a schema

From: Toon Koppelaars <>
Date: Tue, 31 Mar 2009 21:47:45 +0200
Message-ID: <>


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

(co)Author: "Applied Mathematics for Database Professionals"

Received on Tue Mar 31 2009 - 14:47:45 CDT

Original text of this message