User Security Roles Report - SECR0041

Subsystem

Security

Purpose

This report provides a listing of all security roles granted to all or selected users, in alpha order by Oracle Username. Details include a listing of all tables to which the user has been granted access and the access privileges granted for each table

Normally Run By

Security specialist

Anticipated Frequency

As required

Parameter Sample

 

Report Sample

 

Related/Dependent Jobs

N/A

   

Run Details

This job is run:

  • To examine various users access to Callista.
  • For review when consolidating security roles.
  • At any time deemed necessary for any other reason.

Refer to the Job Control and Scheduling subsystem for details of scheduling and running online jobs.

 

Job Parameters

Most parameters for this job are used to refine the data set produced in the report.

The report can be run for individual users or groups of users.

 

Report(s)

User Security Roles Report 

 

The report is presented in landscape mode.

 

Last modified on 11 March 2002