Re: APEX security
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: JBECKSTROM <JBECKSTROM@xxxxxxxxx>
- Date: Wed, 18 Aug 2010 18:09:58 +0200
If by "the default schema", you mean "the parsing schema" of the application
in the workspace that you intend to deploy, then I would say: yes.
On Wed, Aug 18, 2010 at 3:50 PM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote:
> We are new to APEX. We are looking at putting it in our Oracle EBS
> database. We would want APEX to be READONLY to the EBS objects. To do this
> would I do the following:
> - create a new schema as the default schema
> - create a synonym in the new schema pointing to the EBS objects
> - grant select only to the new schema for the EBS objects.
>
> Is this what I would need to do or am I making it more complicated than it
> really is?
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
--
Toon Koppelaars
RuleGen BV
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:
- » APEX security- Jeffrey Beckstrom
- » Re: APEX security - Toon Koppelaars