Security for Oracle Application

Contents

1. The Managing Security for Oracle Application

2. The components of Responsibility• Data Group• Menu• Request Security Group

3. Create and show set up steps for• Menu• Request Set• Request Security Group• Responsibility• Application User

Oracle User Management

Layer 6

• Self Service and approvals

Layer 5

• Registration Processes

Layer 4

• Delegated Administration

Layer 3

• Role Based Access Control

Oracle U

ser Managem

entC

ore security layer

Layer 2

• Data Security

Layer 1

• Function Security

Optional

Requested

Managing Security for Oracle Application

Overview of Function Security

Responsibility

Function

Reports

USER ACCOUNT

Application

The components of Responsibility

Responsibility Components

Data Group

Menu

Request

security group

Exclusions

Define or modify Data group

Define or modify Menu

Define or modify responsibility

Exclude function and menus

Define application user

Define or modify Request group

Using Custom ResponsibilityUsing Predefined

Responsibility

Define application user

Using Responsibilities

Predefined Responsibility

Responsibility Creation Process

Responsibilities

Data Groups

Users

Menus

Request Groups

List of Oracle Applications and the Oracle username assigned to each application.

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

Data Group

Data Group

Data Group Setup

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

Menu

Request Security Group

Request groups can include:

All the report and concurrent programs owned by an application

Individual concurrent requests

Request sets

Stage Functions

Request Security Group

Case Study : Show Step Setup

Chermal acting as the Financial Officer, her job is including all functions, programs and reports as below.

Functions:•Enter Journal•Post Journal•Define Recurring•Generate Recurring•Define MassAllocation•Generate MassAllocation•Account Inquiry•FSG

Programs and Reports:•FSG-Column Set Detail Listing•FSG-Content Set Summary Listing•FSG-Report Set Summary Listing•FSG-Row Order Detail Listing•FSG-Row Set Detail Listing

Case Study for Group 3….

Narwin acting as the Financial Manager, his job is the same as Financial Officer and specific function for Manager as below.

Functions:•Define Budget•Define Budget Organization•Define Budget Formula•Generate Budget Formula•Enter Budget Amounts•Enter Budget Journal•Transfer Budget•Freeze Budget

Case Study for Group 3….

Defining a Menu

Identify menu needs

Print function security report forSimilar existing menus

Plan the menu structure

Start with a blank menu form

1

2

3

5 Build the menu from bottom to top

Assign to the responsibility

7

4

Print function security report set toDocument the new menu

6

Print Function Security Report (Existing menus)

Plan the menu structure

Plan the menu structure

Menu

Used to define a new menu or modify and existing menu.

SubMenu Cont…

Menu Cont…

Print Function Security Report (New menus)

Request Set

Request Set Cont…

Request Set Cont…

Request Security Group

Defining a New Responsibility

Enter application andResponsibility name

Enter start and end dates

Select data group

Select Menu

1

2

3

5 Select request group

Enter menu or function exclusions6

4

Responsibility

3

45

Responsibility Cont…

Defining a New Application UserDefining a New Application User

Enter userName and Password

Require password changeLimit access attempts

Enter User’s start Date

Assign one or moreresponsibilities

1

2

3

4

Steps 1, 3 and 4 are required

Application User - CHERMAL-

Application User - NARWIN-

Responsibility Financial Officer

Responsibility Financial Officer

Responsibility Financial Manager

Responsibility Financial Manager

Questions?