Table: USER_PRIVILEGE
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5289 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
A control table showing what roles have been assigned to what users.
DescriptionA control table showing what roles have been assigned to what users.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
USERNAME
VARCHAR2 |
The oracle id of the system user |
PASSWORD
VARCHAR2 |
The password of the user. |
GROUP_NAME
VARCHAR2 |
The group the user belong to, which controls their level of access. |
PRIVILEGE
VARCHAR2 |
Privilege assigned, ie ADMINISTATOR, DATA_MANAGER. |
CREATED_BY_USER_ID
VARCHAR2 |
An application controlled field showing the userid of the person inserting a record |
CREATED_DATE
DATE |
An application controlled field showing the date and time the record was inserted into the Oracle table |
MODIFIED_BY_USER_ID
VARCHAR2 |
The userid of the last person to edit the data |
MODIFIED_DATE
DATE |
The date of the last update to the record |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
Item Identification
Title: | Table: USER_PRIVILEGE |
---|---|
Short Name: | USER_PRIVILEGE |
Status: | Completed |
Abstract: |
A control table showing what roles have been assigned to what users. |
Notes: |
Loaded by batch 1643, 10-10-2007 10:43 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | EC_SRV_GS |
Description: |
A control table showing what roles have been assigned to what users. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
USERNAME | VARCHAR2 | The oracle id of the system user | |
100
|
PASSWORD | VARCHAR2 | The password of the user. | |
100
|
GROUP_NAME | VARCHAR2 | The group the user belong to, which controls their level of access. | |
100
|
PRIVILEGE | VARCHAR2 | Privilege assigned, ie ADMINISTATOR, DATA_MANAGER. | |
100
|
CREATED_BY_USER_ID | VARCHAR2 | An application controlled field showing the userid of the person inserting a record | |
100
|
CREATED_DATE | DATE | An application controlled field showing the date and time the record was inserted into the Oracle table | |
100
|
MODIFIED_BY_USER_ID | VARCHAR2 | The userid of the last person to edit the data | |
100
|
MODIFIED_DATE | DATE | The date of the last update to the record |
Attribute Details
USERNAME
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The oracle id of the system user |
General Data Type: | VARCHAR2 |
PASSWORD
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The password of the user. |
General Data Type: | VARCHAR2 |
GROUP_NAME
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 256 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The group the user belong to, which controls their level of access. |
General Data Type: | VARCHAR2 |
PRIVILEGE
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Privilege assigned, ie ADMINISTATOR, DATA_MANAGER. |
General Data Type: | VARCHAR2 |
CREATED_BY_USER_ID
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
An application controlled field showing the userid of the person inserting a record |
General Data Type: | VARCHAR2 |
CREATED_DATE
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
An application controlled field showing the date and time the record was inserted into the Oracle table |
General Data Type: | DATE |
MODIFIED_BY_USER_ID
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The userid of the last person to edit the data |
General Data Type: | VARCHAR2 |
MODIFIED_DATE
Seq. Order: | 8 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date of the last update to the record |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 5289 |
---|---|
GUID: | gov.noaa.nmfs.inport:5289 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2007-10-10 10:43+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-07 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-07 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-07 |