Table Privileges and Activities

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Tables and Forms > System Tables (ST) >

Table Privileges and Activities

DT_TABLE

Privileges

Activities

AT_COMPANY_PERSON

READ/WRITE

AT_ tables are associated with RT_COMPANY (COMPANY_CODE) and DT_PERSON (PERSON_NAME)

AT_EQUIPMENT_PARAMETER

READ/WRITE

AT_ tables are associated with RT_COMPANY (COMPANY_CODE) and DT_PERSON (PERSON_NAME)

AT_FACILITY

READ/WRITE

AT_ tables are associated with RT_COMPANY (COMPANY_CODE) and DT_PERSON (PERSON_NAME)

AT_GEO_UNIT

READ/WRITE

AT_ tables are associated with RT_COMPANY (COMPANY_CODE) and DT_PERSON (PERSON_NAME)

AT_SAMPLE_CHAIN_OF_CUSTODY

READ/WRITE

AT_ tables are associated with RT_COMPANY (COMPANY_CODE) and DT_PERSON (PERSON_NAME)

AT_SUBFACILITY_LOCATION

READ/WRITE

AT_ tables are associated with RT_COMPANY (COMPANY_CODE) and DT_PERSON (PERSON_NAME)

AT_TEST_BATCH_ASSIGN

READ/WRITE

AT_tables are associated with RT_COMPANY (COMPANY_CODE) and DT_PERSON (PERSON_NAME)

AT_TABLES

READ/WRITE

Associative tables used for many-to-many relationships

DT_TABLES

READ/WRITE

Read only capabilities allow user to read and report on data tables

DT_TABLES

READ/WRITE

Read/Write capabilities allow user to read and write to tables in Professional and EDP

 

RT_TABLE

Privileges

Activities

RT_TABLES

READ/WRITE

Read Only capabilities will not affect reporting, however, a user with Read Only on RT_TABLES in EDP will not be able to approve new reference values

RT_TABLES

READ/WRITE

Read/Write capabilities will allow user to create reference values in Professional, and approve reference values in EDP

 

ST_TABLE

Privileges

Activities

ST_ARCGIS

READ/WRITE

Read/write required for EQuIS for ArcGIS Server Enterprise account to read and modify certain configuration settings

ST_CLIENT

READ/WRITE

Read/Write requirements needed

ST_CONFIG



ST_EDD_BATCH

READ/WRITE

Read/write required for Professional/Enterprise accounts which need to create and commit EDDs

ST_FILE_REGISTRATION

READ/WRITE

Read/write requirements needed

ST_GROUP_TYPE



ST_JOB



ST_LICENSE

READ

Read required for access to network licenses

ST_LICENSE_USE

READ/WRITE

Read/write required to check out a network license

ST_NEXT_ID

READ/WRITE

Read/write required to add data, save user (pick) reports and create EDDs

ST_NOTICE

READ/WRITE

Read/write required for Enterprise account to send notices

ST_NOTICE_ATTACHMENT

READ/WRITE

Read/write required for Enterprise account to send notices with attachments

ST_NOTICE_TEMPLATE

READ

Read required for Enterprise to send notices

ST_REPORT

READ

Read required for reporting

ST_REPORT_EVENT

READ/WRITE

Read/write required for Enterprise to create an EIA

ST_REPORT_EVENT_JOB

READ/WRITE

Read/write required for Enterprise to successfully execute an EIA

ST_REPORT_PARAMETER

READ

Read required for reporting

ST_REPORT_TASK

READ/WRITE

Read/write required for Enterprise

ST_REPORT_TYPE

READ

Read required for publishing a report

ST_REPORT_USE

READ/WRITE

Read/write required for Enterprise to track report usage

ST_ROLE

READ/WRITE

Read required for Application Level Security

ST_SERVICE_RESERVATION

READ/WRITE

Read/write required for managing Enterprise Workflow

ST_SPLA



ST_TASK



ST_USER

READ/WRITE

Read/write required for user account creation in EQuIS Enterprise

ST_USER_NOTICE

READ/WRITE

Read/write required by Enterprise for user notice tracking

ST_USER_REPORT

READ/WRITE

Read/write required to save a user report

ST_USER_REPORT_PARAMETER

READ/WRITE

Read/write required to save a user report

ST_USER_ROLE

READ/WRITE

Read/write required by Enterprise to assign user a role

ST_VERSION