Oracle Forms (MOSC)

MOSC Banner

Restricting View Access

edited Sep 9, 2015 10:02AM in Oracle Forms (MOSC) 5 commentsAnswered
Dear All,
I have a requirement, where our organization would like to restrict the supplier / customer data being viewed by the unrelated users.   Here goes the details.

Setup
=====
One OU

Requirement
==========
At supplier / customer level we are planning to tag the Region codes.  Similarly, We are planning to create User + Regional mapping lookups

For Example
===========

Supplier                   Region Map
-------------------------------------
S1                           EAST
S2                           WEST
S3                           NORTH,SOUTH

USER                   REGION
------------------------------ 
U1                       SOUTH
U2                       EAST, WEST
U3                       NORTH, SOUTH

So, the user U1 should be able to view / create the transactions only for those suppliers who are tagged to region SOUTH
Similarly, the user U2 should be able to view / create the transactions only for those suppliers who are tagged to either region: EAST / or WEST

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center