Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/Observer Logistics System (OLS) >

Table: OLS_LOV_USER_PAGES

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12306  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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