Table: OLS_LOV_USER_PAGES
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12306 | Updated: August 9, 2022 | Published / External
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
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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 |