Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: OLS_LOV_USER_PAGES
Short Name: OLS_LOV_USER_PAGES
Status: Completed
Abstract:

Defines what roles in oracle have what access to what pages in an apex application. This table provides the vehicle by which user access (through granted database roles) to various sections of the APEX user interface is controled.

Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

Defines what roles in oracle have what access to what pages in an apex application. This table provides the vehicle by which user access (through granted database roles) to various sections of the APEX user interface is controled.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
USER_PAGES_SEQ NUMBER Oracle sequence generated unique identifier of a user page permissions record.
100
APPLICATION_ID NUMBER APEX application id for the application being controlled
100
PAGE_NUMBER NUMBER APEX application page number
100
ROLE VARCHAR2 Oracle role controlling the page access
100
READ VARCHAR2 Flag indicating the permission to allow role to read page
100
ADD_UPDATE VARCHAR2 Y|N to allow role toadd - update page
100
DELETE_DATA VARCHAR2 indicates if user role can delete data on an application page.

Attribute Details

USER_PAGES_SEQ

CC ID: 65229
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Oracle sequence generated unique identifier of a user page permissions record.

General Data Type: NUMBER

APPLICATION_ID

CC ID: 65230
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

APEX application id for the application being controlled

General Data Type: NUMBER

PAGE_NUMBER

CC ID: 65231
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

APEX application page number

General Data Type: NUMBER

ROLE

CC ID: 65232
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Oracle role controlling the page access

General Data Type: VARCHAR2

READ

CC ID: 65233
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Flag indicating the permission to allow role to read page

General Data Type: VARCHAR2

ADD_UPDATE

CC ID: 65234
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Y|N to allow role toadd - update page

General Data Type: VARCHAR2

DELETE_DATA

CC ID: 65235
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

indicates if user role can delete data on an application page.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 12306
GUID: gov.noaa.nmfs.inport:12306
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-04-19 13:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26