Diversity Collection Cache
ROLES
The following objects are not included:
- Logging tables
- Enumeration tables
- System objects
- Objects marked as obsolete
- Previous versions of objects
Role CacheAdmin
Read/write access to objects related to cache database
Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
---|---|---|---|---|---|---|
AnnotationType_Enum | User | TABLE | ||||
CollCircumstances_Enum | User | TABLE | ||||
CollCollectionImageType_Enum | User | TABLE | ||||
CollCollectionType_Enum | User | TABLE | ||||
CollDateCategory_Enum | User | TABLE | ||||
CollEventDateCategory_Enum | User | TABLE | ||||
CollEventImageType_Enum | User | TABLE | ||||
CollEventSeriesDescriptorType_Enum | TABLE | |||||
CollEventSeriesImageType_Enum | User | TABLE | ||||
CollExchangeType_Enum | User | TABLE | ||||
CollIdentificationCategory_Enum | User | TABLE | ||||
CollIdentificationDateCategory_Enum | User | TABLE | ||||
CollIdentificationQualifier_Enum | User | TABLE | ||||
CollLabelTranscriptionState_Enum | User | TABLE | ||||
CollLabelType_Enum | User | TABLE | ||||
CollMaterialCategory_Enum | User | TABLE | ||||
CollRetrievalType_Enum | User | TABLE | ||||
CollSpecimenImageType_Enum | User | TABLE | ||||
CollSpecimenRelationType_Enum | User | TABLE | ||||
CollTaskMetricAggregation_Enum | User | TABLE | ||||
CollTaxonomicGroup_Enum | User | TABLE | ||||
CollTransactionType_Enum | User | TABLE | ||||
CollTypeStatus_Enum | User | TABLE | ||||
CollUnitRelationType_Enum | User | TABLE | ||||
EntityAccessibility_Enum | User | TABLE | ||||
EntityContext_Enum | User | TABLE | ||||
EntityDetermination_Enum | User | TABLE | ||||
EntityLanguageCode_Enum | User | TABLE | ||||
EntityUsage_Enum | User | TABLE | ||||
EntityVisibility_Enum | User | TABLE | ||||
LanguageCode_Enum | TABLE | |||||
MeasurementUnit_Enum | TABLE | |||||
ParameterValue_Enum | User | TABLE | ||||
PropertyType_Enum | TABLE | |||||
RegulationType_Enum | User | TABLE | ||||
TaskDateType_Enum | User | TABLE | ||||
TaskModuleType_Enum | User | TABLE | ||||
TaskType_Enum | User | TABLE | ||||
ViewCollectionSpecimenImage | User | VIEW | ||||
ViewIdentificationUnitGeoAnalysis | User | VIEW | ||||
DiversityWorkbenchModule | User | FUNCTION | ||||
Version | User | FUNCTION | ||||
Inheriting from roles: |
- CacheUser
Role CacheUser
Reading access to objects related to the cache database
Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
---|---|---|---|---|---|---|
AnnotationType_Enum | User | TABLE | ||||
CollCircumstances_Enum | User | TABLE | ||||
CollCollectionImageType_Enum | User | TABLE | ||||
CollCollectionType_Enum | User | TABLE | ||||
CollDateCategory_Enum | User | TABLE | ||||
CollEventDateCategory_Enum | User | TABLE | ||||
CollEventImageType_Enum | User | TABLE | ||||
CollEventSeriesDescriptorType_Enum | TABLE | |||||
CollEventSeriesImageType_Enum | User | TABLE | ||||
CollExchangeType_Enum | User | TABLE | ||||
CollIdentificationCategory_Enum | User | TABLE | ||||
CollIdentificationDateCategory_Enum | User | TABLE | ||||
CollIdentificationQualifier_Enum | User | TABLE | ||||
CollLabelTranscriptionState_Enum | User | TABLE | ||||
CollLabelType_Enum | User | TABLE | ||||
CollMaterialCategory_Enum | User | TABLE | ||||
CollRetrievalType_Enum | User | TABLE | ||||
CollSpecimenImageType_Enum | User | TABLE | ||||
CollSpecimenRelationType_Enum | User | TABLE | ||||
CollTaskMetricAggregation_Enum | User | TABLE | ||||
CollTaxonomicGroup_Enum | User | TABLE | ||||
CollTransactionType_Enum | User | TABLE | ||||
CollTypeStatus_Enum | User | TABLE | ||||
CollUnitRelationType_Enum | User | TABLE | ||||
EntityAccessibility_Enum | User | TABLE | ||||
EntityContext_Enum | User | TABLE | ||||
EntityDetermination_Enum | User | TABLE | ||||
EntityLanguageCode_Enum | User | TABLE | ||||
EntityUsage_Enum | User | TABLE | ||||
EntityVisibility_Enum | User | TABLE | ||||
LanguageCode_Enum | TABLE | |||||
MeasurementUnit_Enum | TABLE | |||||
ParameterValue_Enum | User | TABLE | ||||
PropertyType_Enum | TABLE | |||||
RegulationType_Enum | User | TABLE | ||||
TaskDateType_Enum | User | TABLE | ||||
TaskModuleType_Enum | User | TABLE | ||||
TaskType_Enum | User | TABLE | ||||
ViewCollectionSpecimenImage | User | VIEW | ||||
ViewIdentificationUnitGeoAnalysis | User | VIEW | ||||
DiversityWorkbenchModule | User | FUNCTION | ||||
Version | User | FUNCTION | ||||
Inheriting from roles: |
- User