System Security Roles Report (SECRC044) New for Release 10.1

Introduction

This report is part of Callista Staff Connect and is used to provide a list of all selected system security roles and details of those roles, and details of any privileges on views assigned to roles.

After logging onto Staff Connect, the Report is accessed from the main screen. The report (System Security Roles Report) can be found from a list under the Reports heading on the left-hand side of the main screen.

Different information entered into the fields determines what is in the report. Although the reports have a uniform appearance, the data determines the size and content of the report. The user has the choice of viewing the report in DELIMITEDDATA, PDF or XML.

The screen information is based on the existing System Security Roles Report (SECR0044) in SMS.

Refer to the Job Control and Scheduling Subsystem for details on scheduling and running immediate and batch jobs.

The different sections are:

 

 

Example of Screen Layout

example of screen

 

 

Fields

System Security Roles Report (SECRC044)

 

Run Details

 

 

Field Attributes

Prompt

Field Type

Data Type, Length & Format Mask

Comments

Comment

Input Field

VARCHAR2(50)

Field set in s_job_parameter

Output Format

Poplist

VARCHAR(10)

This field is populated from table  JOB_OUTPUT_TYPE.S_OUTPUT_TYPE. The default value is the first alphabetical sort order value in this column

Immediate

Button

N/A

Run Oracle Report SECR0044 in immediate mode with the page parameters and selected report output format type

Batch

Button

N/A

Run Oracle Report SECR0044 in batch mode with the page parameters and selected report output format type

 

 

Example of a Report

This is an example from only one page of the report produced as a pdf. There are other pages to the report, and depending on selected criteria, what is displayed. Delimited or XML reports will have different layouts.

 

example of a report

 

 

Last Modified on 20 December, 2007 1:00 PM

History Information

Release Information Project Change to Document
10.1.0.0.0.0 1345 - Change Report Output Format New Document