Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Economic Data Collections for Gulf of Mexico &... > Economic Data Collection for Gulf of Mexico Sou... >

Table: USER_PRIVILEGE

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

Summary

Abstract

A control table showing what roles have been assigned to what users.

Description

A 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

Rubric Score Primary Key? 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

CC ID: 15405
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

CC ID: 15404
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

CC ID: 15403
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

CC ID: 15402
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

CC ID: 15401
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

CC ID: 15400
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

CC ID: 15399
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

CC ID: 15398
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