Re: Application Express access to a schema

  • From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
  • To: JBECKSTROM@xxxxxxxxx
  • Date: Tue, 31 Mar 2009 21:47:45 +0200

Yes.

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@xxxxxxxxx>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@xxxxxxxxxxx
www.RuleGen.com
thehelsinkideclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13

Other related posts: