Explain the Managing Security Explain the Managing Security for Oracle Applicationfor Oracle Application

1

Explain the components of Explain the components of ResponsibilityResponsibility

2

3

Data Group

Application User

Menu

Request Security Group

Responsibility

Menu

Request Set

Request Group

Create and show set up Create and show set up steps:steps:

Explain the Managing Security for Oracle Application1

Responsibility

Oracle Oracle ApplicationApplication

Windows

Reports

USER

Explain the Managing Security for Oracle ApplicationExplain the Managing Security for Oracle Application1

Explain the Managing Security for Oracle Application1

Using Using CustomCustom Responsibility ResponsibilityUsing Using PredefinedPredefined Responsibility Responsibility

Using ResponsibilitiesUsing Responsibilities

Define/Modify Data Group

Define/Modify Menu

Define/ModifyRequest Group

DefineApplication User

Assign to User

Define/Modify Responsibility

ExcludeFunctions & Menu

DefineApplication User

Explain the components of Responsibility2

1.Data Group

3.Request Security

Group

2.Menu Exclusion

Explain the components of Responsibility2

What is a Data Group?What is a Data Group?A collection of pairings of an application with an Oracle ID.

Each application in a data group must have a Oracle username assigned to it.

It identifies the Oracle username that forms connect to when you select the responsibility.

Concurrent managers use a data group to match the application that owns a report or concurrent program (submitted by a user of the responsibility) with a Oracle username.

Purpose of Data GroupPurpose of Data Group

Explain the components of Responsibility2

Explain the components of Responsibility2

Menu is a required components of a Responsibility.

Menu is a customize forms that responsibility can display and access functions.

Menu is a hierarchical arrangement of functions and menus of functions.

Recommend that use exclusion rules to customize a responsibility to constructing a new menu.

Each application in a data group must have a Oracle username assigned to it..

Explain the components of Responsibility2

Identify menu needs

Print function security report for

similar existing menus

Start with a blank menu form

Print a function security report set to document the new menu

Build the menu from bottom to top

Plan the menu structure

Assign to the responsibility

Defining a New Menu StructureDefining a New Menu Structure

similar existing menus

Explain the components of Responsibility2

Exiting Menu StructuresExiting Menu Structures

Function Security Menu Report

Function Security Navigator Report

Function Security Function Report

Explain the components of Responsibility2

12

3

4

5

6

Explain the components of Responsibility2

7

8

Explain the components of Responsibility2

Function Security Menu Report

Explain the components of Responsibility2

Function Security Navigator Report

Explain the components of Responsibility2

Function Security Function Report

Explain the components of Responsibility2

Defining a New Menu StructureDefining a New Menu Structure

Identify menu needs

Print function security report for similar existing menus

Start with a blank menu form

Print a function security report set to document the new menu

Build the menu from bottom to top

Plan the menu structure

Assign to the responsibility

Explain the components of Responsibility2

Menu GuidelinesMenu GuidelinesDesign prompts with unique first letters (typing the first letter will automatically select it).

Sequence the prompt with the most frequently used functions first.

Entries cannot be copied from one menu definition to another.

Use acronyms when an industry term is written as such.

Use integer in numbering.

Explain the components of Responsibility2

Identify menu needs

Print function security report for similar existing menus

Start with a blank menu form

Print a function security report set to document the new menu

Build the menu from bottom to top

Plan the menu structure

Assign to the responsibility

Defining a New Menu StructureDefining a New Menu Structure

Explain the components of Responsibility2

Request groups can include:Request groups can include:

All the report and concurrent programs owned by an application

Individual concurrent requests

Request sets

Stage Functions

Explain the components of Responsibility2

Application User

Responsibility

Menu

Request Set

Request Group

Create and show set up steps forCreate and show set up steps for3

Create and show set up steps Create and show set up steps 3

User   KhemanitKhemanit ArerakArerak PakornPakornResponsibility Name G3 FINANCIAL OFFICER G3_PROJECT PLANNING ANALYST G3_IMPLEMENTER

DataGroupName Standard Standard G3 Implementer Data Group

Application General Ledger General Ledger G3 Implementer ApplicationRequest Group G3 Financial Officer G3_Project Planning Analyst G3 Implementer

Menu

Name G3 FINANCIAL OFFICER G3_PROJECT_PLAN_ANALYST G3_IM_SETUP_GLLevel 1 G3 FINANCIAL OFFICER G3_PROJECT_PLAN_ANALYST G3_IM_SETUP_GL

Level 2

G3 JOURNAL G3_BUDGET G3_IM_FING3 INQUIRY G3_REPORT G3_IM_S_SECURG3 REPORT G3_INQUIRY G3_IM_S_APPLI  G3_FINANCIAL REPORT G3_IM_S_REQUESTS    G3_IM_S_PROFINE

Level 3

G3 DEFINE G3_DEFINE

G3_IM_FLEX

G3 GENERATE G3_GENERATEG3 RUNFINANCIAL_RE GE_ENTER  G3_FINANCIAL REPORT  G3_FINANCIAL REPORT  G3_DEFINE FIN

Level 4

    G3_IM_CURR    G3_IM_CAL    G3_IM_VALIDATION    G3_IM_KEY    G3_IM_ACC    G3_IM_SEQ    G3_IM_JOUR    G3_IM_S_UER    G3_IM_S_RESP    G3_IM_S_DATA_G

Summary Requirement

Microsoft Office Excel 97-2003 Worksheet

Responsibility Component – Data GroupResponsibility Component – Data Group

Standard Data GroupStandard Data Group

1

2

4

3

(N) Security -> Oracle -> DataGroup(N) Security -> Oracle -> DataGroup

3

1

2

(N) Requests -> Set(N) Requests -> Set

12

3

4

(N) Requests -> Set(N) Requests -> Set

(N) Security -> Responsibility -> Request(N) Security -> Responsibility -> Request

(N) Application -> Menu(N) Application -> Menu

Menu Level 3Menu Level 3

Menu Level 2Menu Level 2

Menu Level 1Menu Level 1

1 2

3

4

6

5

(N) Security -> Responsibility -> Define(N) Security -> Responsibility -> Define

Company Logo

1

2

3

(N) Security -> User -> Define(N) Security -> User -> Define