Diversity Collection

Roles

Role Administrator

Administrator of the database. Read/write access to all objects

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis Editor Data Manager Data Manager TABLE
Analysis_log Data Manager TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User Data Manager Data Manager TABLE
Annotation_log Editor Editor TABLE
AnnotationType_Enum User TABLE
AnonymCollector Cache User Cache Admin Cache Admin Cache Admin TABLE
CacheDatabase2 Cache User Cache Admin TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection Editor Editor TABLE
Collection_log Editor Editor TABLE
CollectionAgent User Editor Editor TABLE
CollectionAgent_log Editor Editor TABLE
CollectionEvent User Editor Editor TABLE
CollectionEvent_log Editor Editor TABLE
CollectionEventImage User Editor Editor TABLE
CollectionEventImage_log Editor Editor TABLE
CollectionEventLocalisation User Typist Typist Editor TABLE
CollectionEventLocalisation_log Typist Typist TABLE
CollectionEventMethod User Data Manager Data Manager Data Manager TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User Data Manager Data Manager Data Manager TABLE
CollectionEventParameterValue_log Editor Editor TABLE
CollectionEventProperty User Typist Typist Editor TABLE
CollectionEventProperty_log Typist Typist TABLE
CollectionEventRegulation User Editor Editor TABLE
CollectionEventRegulation_log Editor Editor TABLE
CollectionEventSeries User Editor Typist Editor TABLE
CollectionEventSeries_log Typist Typist TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User Editor Typist Editor TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager Collection Manager TABLE
CollectionProject User Editor Editor TABLE
CollectionProject_log Editor Editor TABLE
CollectionSpecimen Typist Editor Editor TABLE
CollectionSpecimen_log Editor Editor TABLE
CollectionSpecimenImage Typist Editor Editor TABLE
CollectionSpecimenImage_log Typist Typist TABLE
CollectionSpecimenImageProperty User Editor Editor Editor TABLE
CollectionSpecimenImageProperty_log Editor Editor TABLE
CollectionSpecimenPart User Typist Typist Editor TABLE
CollectionSpecimenPart_log Typist Typist TABLE
CollectionSpecimenPartDescription User Editor Editor Editor TABLE
CollectionSpecimenPartDescription_log Editor Editor TABLE
CollectionSpecimenProcessing User Editor Editor Editor TABLE
CollectionSpecimenProcessing_log Typist Typist TABLE
CollectionSpecimenProcessingMethod User Editor Editor Editor TABLE
CollectionSpecimenProcessingMethod_log Editor Editor TABLE
CollectionSpecimenProcessingMethodParameter User Editor Editor Editor TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User Editor Editor Editor TABLE
CollectionSpecimenReference_log Editor Editor TABLE
CollectionSpecimenRelation User Editor Editor TABLE
CollectionSpecimenRelation_log Editor Editor TABLE
CollectionSpecimenTransaction User Typist Typist Editor TABLE
CollectionSpecimenTransaction_log Typist Typist TABLE
CollectionTask User Collection Manager Collection Manager Collection Manager TABLE
CollectionTask_log Collection Manager Collection Manager TABLE
CollectionTaskImage User Collection Manager Collection Manager Collection Manager TABLE
CollectionTaskImage_log Collection Manager Collection Manager TABLE
CollectionTaskMetric User Collection Manager Collection Manager Collection Manager TABLE
CollectionTaskMetric_log Collection Manager Collection Manager TABLE
CollEventDateCategory_Enum Editor TABLE
CollEventImageType_Enum Editor TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum User TABLE
CollExchangeType_Enum Editor TABLE
CollIdentificationCategory_Enum Editor TABLE
CollIdentificationDateCategory_Enum User TABLE
CollIdentificationQualifier_Enum User TABLE
CollLabelTranscriptionState_Enum User TABLE
CollLabelType_Enum Editor 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
Entity User TABLE
EntityAccessibility_Enum TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User Editor Editor Editor TABLE
ExternalIdentifier_log Editor Editor TABLE
ExternalIdentifierType User TABLE
ExternalIdentifierType_log TABLE
Identification User Typist Typist TABLE
Identification_log Editor Editor TABLE
IdentificationUnit User Editor Editor TABLE
IdentificationUnit_log Editor Editor TABLE
IdentificationUnitAnalysis User Editor Editor TABLE
IdentificationUnitAnalysis_log Typist Typist TABLE
IdentificationUnitAnalysisMethod User Editor Editor Editor TABLE
IdentificationUnitAnalysisMethod_log Editor Editor TABLE
IdentificationUnitAnalysisMethodParameter User Editor Editor Editor TABLE
IdentificationUnitAnalysisMethodParameter_log Editor Editor TABLE
IdentificationUnitGeoAnalysis User Editor Editor Editor TABLE
IdentificationUnitGeoAnalysis_log Editor TABLE
IdentificationUnitInPart User Typist Typist Editor TABLE
IdentificationUnitInPart_log Typist Typist TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User Data Manager Data Manager TABLE
Processing_log Editor Data Manager TABLE
ProcessingMaterialCategory User Data Manager Data Manager TABLE
ProjectAnalysis User Data Manager Data Manager TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User Data Manager Data Manager TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher Editor TABLE
Task User Collection Manager Collection Manager TABLE
Task_log Collection Manager Collection Manager TABLE
TaskDateType_Enum User TABLE
TaskModule User Collection Manager Collection Manager Collection Manager TABLE
TaskModule_log Collection Manager Collection Manager TABLE
TaskModuleType_Enum User TABLE
TaskResult User Collection Manager Collection Manager Collection Manager TABLE
TaskResult_log Collection Manager Collection Manager TABLE
TaskType_Enum User TABLE
Transaction User Collection Manager Collection Manager TABLE
Transaction_log Typist Typist TABLE
TransactionAgent Transaction User Collection Manager Collection Manager Collection Manager TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument User Typist Typist TABLE
TransactionDocument_log Typist Typist TABLE
TransactionPayment Transaction User Collection Manager Collection Manager Collection Manager TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString Editor FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List Editor FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List Editor FUNCTION
CollEventImageType_List Editor FUNCTION
CollExchangeType_List Editor FUNCTION
CollIdentificationCategory_List Editor FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List Editor FUNCTION
CuratorCollectionHierarchyList Collection Manager FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList Collection Manager FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr Typist FUNCTION
NextFreeAccNumber Editor FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 Editor PROCEDURE
procCopyCollectionSpecimenPart Editor PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent Editor PROCEDURE
procSetVersionCollectionSpecimen Editor PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • Replicator
  • DataManager
  • CacheAdmin
  • CollectionManager
  • Editor

Role AdminNonProject

Permissions as Administrator without permission to change projects

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis Editor Data Manager Data Manager Administrator TABLE
Analysis_log Data Manager TABLE
AnalysisResult User Administrator Administrator Administrator TABLE
AnalysisTaxonomicGroup User Administrator Administrator Administrator TABLE
Annotation User User Data Manager Data Manager TABLE
Annotation_log Editor Editor TABLE
AnnotationType_Enum User TABLE
AnonymCollector Cache User Cache Admin Cache Admin Cache Admin TABLE
CacheDatabase2 Cache User Cache Admin TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User Administrator Administrator Administrator TABLE
CollCollectionType_Enum User Administrator Administrator Administrator TABLE
CollDateCategory_Enum User Administrator Administrator Administrator TABLE
Collection Editor Administrator Editor Administrator TABLE
Collection_log Editor Editor TABLE
CollectionAgent User Editor Editor Administrator TABLE
CollectionAgent_log Editor Editor TABLE
CollectionEvent User Editor Editor Administrator TABLE
CollectionEvent_log Editor Editor TABLE
CollectionEventImage User Editor Editor Administrator TABLE
CollectionEventImage_log Editor Editor TABLE
CollectionEventLocalisation User Typist Typist Editor TABLE
CollectionEventLocalisation_log Typist Typist TABLE
CollectionEventMethod User Data Manager Data Manager Data Manager TABLE
CollectionEventMethod_log Administrator TABLE
CollectionEventParameterValue User Data Manager Data Manager Data Manager TABLE
CollectionEventParameterValue_log Editor Editor TABLE
CollectionEventProperty User Typist Typist Editor TABLE
CollectionEventProperty_log Typist Typist TABLE
CollectionEventRegulation User Editor Editor Administrator TABLE
CollectionEventRegulation_log Editor Editor Administrator TABLE
CollectionEventSeries User Editor Typist Editor TABLE
CollectionEventSeries_log Typist Typist TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User Editor Typist Editor TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User Administrator Administrator Administrator TABLE
CollectionExternalDatasource_log TABLE
CollectionImage Administrator Administrator Administrator Administrator TABLE
CollectionImage_log Administrator Administrator TABLE
CollectionManager Collection Manager Administrator Administrator Administrator TABLE
CollectionProject User Editor Editor Administrator TABLE
CollectionProject_log Editor Editor TABLE
CollectionSpecimen Typist Editor Editor Administrator TABLE
CollectionSpecimen_log Editor Editor Administrator TABLE
CollectionSpecimenImage Typist Editor Editor Administrator TABLE
CollectionSpecimenImage_log Typist Typist TABLE
CollectionSpecimenImageProperty User Editor Editor Editor TABLE
CollectionSpecimenImageProperty_log Editor Editor TABLE
CollectionSpecimenPart User Typist Typist Editor TABLE
CollectionSpecimenPart_log Typist Typist TABLE
CollectionSpecimenPartDescription User Editor Editor Editor TABLE
CollectionSpecimenPartDescription_log Editor Editor TABLE
CollectionSpecimenProcessing User Editor Editor Editor TABLE
CollectionSpecimenProcessing_log Typist Typist TABLE
CollectionSpecimenProcessingMethod User Editor Editor Editor TABLE
CollectionSpecimenProcessingMethod_log Editor Editor Administrator TABLE
CollectionSpecimenProcessingMethodParameter User Editor Editor Editor TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User Editor Editor Editor TABLE
CollectionSpecimenReference_log Editor Editor TABLE
CollectionSpecimenRelation User Editor Editor Administrator TABLE
CollectionSpecimenRelation_log Editor Editor TABLE
CollectionSpecimenTransaction User Typist Typist Editor TABLE
CollectionSpecimenTransaction_log Typist Typist TABLE
CollectionTask User Collection Manager Collection Manager Collection Manager TABLE
CollectionTask_log Collection Manager Collection Manager TABLE
CollectionTaskImage User Collection Manager Collection Manager Collection Manager TABLE
CollectionTaskImage_log Collection Manager Collection Manager TABLE
CollectionTaskMetric User Collection Manager Collection Manager Collection Manager TABLE
CollectionTaskMetric_log Collection Manager Collection Manager TABLE
CollEventDateCategory_Enum Editor Administrator Administrator Administrator TABLE
CollEventImageType_Enum Editor Administrator Administrator Administrator TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum User TABLE
CollExchangeType_Enum Editor Administrator Administrator Administrator TABLE
CollIdentificationCategory_Enum Editor Administrator Administrator Administrator TABLE
CollIdentificationDateCategory_Enum User Administrator Administrator Administrator TABLE
CollIdentificationQualifier_Enum User Administrator Administrator Administrator TABLE
CollLabelTranscriptionState_Enum User Administrator Administrator Administrator TABLE
CollLabelType_Enum Editor Administrator Administrator Administrator TABLE
CollMaterialCategory_Enum User Administrator Administrator Administrator TABLE
CollRetrievalType_Enum User Administrator Administrator Administrator TABLE
CollSpecimenImageType_Enum User Administrator Administrator Administrator TABLE
CollSpecimenRelationType_Enum User TABLE
CollTaskMetricAggregation_Enum User Administrator Administrator Administrator TABLE
CollTaxonomicGroup_Enum User Administrator Administrator Administrator TABLE
CollTransactionType_Enum User TABLE
CollTypeStatus_Enum User Administrator Administrator Administrator TABLE
CollUnitRelationType_Enum User TABLE
Entity User Administrator Administrator Administrator TABLE
EntityAccessibility_Enum Administrator TABLE
EntityContext_Enum User Administrator Administrator Administrator TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User Administrator Administrator Administrator TABLE
EntityRepresentation User Administrator Administrator Administrator TABLE
EntityUsage User Administrator Administrator Administrator TABLE
EntityUsage_Enum User Administrator Administrator Administrator TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User Editor Editor Editor TABLE
ExternalIdentifier_log Editor Editor TABLE
ExternalIdentifierType User Administrator Administrator Administrator TABLE
ExternalIdentifierType_log Administrator Administrator TABLE
Identification User Typist Typist Administrator TABLE
Identification_log Editor Editor TABLE
IdentificationUnit User Editor Editor Administrator TABLE
IdentificationUnit_log Editor Editor TABLE
IdentificationUnitAnalysis User Editor Editor Administrator TABLE
IdentificationUnitAnalysis_log Typist Typist TABLE
IdentificationUnitAnalysisMethod User Editor Editor Editor TABLE
IdentificationUnitAnalysisMethod_log Editor Editor Administrator TABLE
IdentificationUnitAnalysisMethodParameter User Editor Editor Editor TABLE
IdentificationUnitAnalysisMethodParameter_log Editor Editor Administrator TABLE
IdentificationUnitGeoAnalysis User Editor Editor Editor TABLE
IdentificationUnitGeoAnalysis_log Editor TABLE
IdentificationUnitInPart User Typist Typist Editor TABLE
IdentificationUnitInPart_log Typist Typist TABLE
LanguageCode_Enum TABLE
LocalisationSystem User Administrator Administrator Administrator TABLE
MeasurementUnit_Enum TABLE
Method User Administrator Administrator Administrator TABLE
Method_log Administrator TABLE
MethodForAnalysis User Administrator Administrator Administrator TABLE
MethodForProcessing User Administrator Administrator Administrator TABLE
Parameter User Administrator Administrator Administrator TABLE
Parameter_log TABLE
ParameterValue_Enum User Administrator Administrator Administrator TABLE
Processing User Data Manager Data Manager Administrator TABLE
Processing_log Editor Data Manager TABLE
ProcessingMaterialCategory User Data Manager Data Manager Administrator TABLE
ProjectAnalysis User Data Manager Data Manager Administrator TABLE
ProjectMaterialCategory User Administrator Administrator Administrator TABLE
ProjectProcessing User Data Manager Data Manager Administrator TABLE
ProjectTaxonomicGroup User Administrator Administrator Administrator TABLE
ProjectUser Administrator Administrator Administrator Administrator TABLE
Property User Administrator Administrator TABLE
PropertyType_Enum TABLE
RegulationType_Enum User Administrator Administrator TABLE
ReplicationPublisher Editor Administrator Administrator TABLE
Task User Collection Manager Collection Manager Administrator TABLE
Task_log Collection Manager Collection Manager TABLE
TaskDateType_Enum User TABLE
TaskModule User Collection Manager Collection Manager Collection Manager TABLE
TaskModule_log Collection Manager Collection Manager TABLE
TaskModuleType_Enum User TABLE
TaskResult User Collection Manager Collection Manager Collection Manager TABLE
TaskResult_log Collection Manager Collection Manager TABLE
TaskType_Enum User Administrator Administrator Administrator TABLE
Transaction User Collection Manager Collection Manager Administrator TABLE
Transaction_log Typist Typist TABLE
TransactionAgent Transaction User Collection Manager Collection Manager Collection Manager TABLE
TransactionAgent_log TABLE
TransactionComment User Administrator Administrator Administrator TABLE
TransactionDocument User Typist Typist Administrator TABLE
TransactionDocument_log Typist Typist TABLE
TransactionPayment Transaction User Collection Manager Collection Manager Collection Manager TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString Editor FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List Editor FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List Editor FUNCTION
CollEventImageType_List Editor FUNCTION
CollExchangeType_List Editor FUNCTION
CollIdentificationCategory_List Editor FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List Editor FUNCTION
CuratorCollectionHierarchyList Collection Manager FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList Collection Manager FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr Typist FUNCTION
NextFreeAccNumber Editor FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 Editor PROCEDURE
procCopyCollectionSpecimenPart Editor PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent Editor PROCEDURE
procSetVersionCollectionSpecimen Editor PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • Administrator

Role CacheAdmin

Read/write access to objects related to cache database

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis User TABLE
Analysis_log TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User User TABLE
Annotation_log TABLE
AnnotationType_Enum User TABLE
AnonymCollector Cache User TABLE
CacheDatabase2 Cache User TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection User TABLE
Collection_log TABLE
CollectionAgent User TABLE
CollectionAgent_log TABLE
CollectionEvent User TABLE
CollectionEvent_log TABLE
CollectionEventImage User TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation User TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod User TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty User TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation User TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries User TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage User TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject User TABLE
CollectionProject_log TABLE
CollectionSpecimen User TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage User TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty User TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart User TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription User TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing User TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod User TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter User TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation User TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction User TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask User TABLE
CollectionTask_log TABLE
CollectionTaskImage User TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric User TABLE
CollectionTaskMetric_log 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
Entity User TABLE
EntityAccessibility_Enum User TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType User TABLE
ExternalIdentifierType_log TABLE
Identification User TABLE
Identification_log TABLE
IdentificationUnit User TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis User TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod User TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter User TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis User TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart User TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User TABLE
Processing_log TABLE
ProcessingMaterialCategory User TABLE
ProjectAnalysis User TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser User TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher TABLE
Task User TABLE
Task_log TABLE
TaskDateType_Enum User TABLE
TaskModule User TABLE
TaskModule_log TABLE
TaskModuleType_Enum User TABLE
TaskResult User TABLE
TaskResult_log TABLE
TaskType_Enum User TABLE
Transaction User TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument User TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List User FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List User FUNCTION
CollEventImageType_List User FUNCTION
CollExchangeType_List User FUNCTION
CollIdentificationCategory_List User FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List User FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • CacheUser

Role CacheUser

Reading access to objects related to the cache database

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis User TABLE
Analysis_log TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User User TABLE
Annotation_log TABLE
AnnotationType_Enum User TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection User TABLE
Collection_log TABLE
CollectionAgent User TABLE
CollectionAgent_log TABLE
CollectionEvent User TABLE
CollectionEvent_log TABLE
CollectionEventImage User TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation User TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod User TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty User TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation User TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries User TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage User TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject User TABLE
CollectionProject_log TABLE
CollectionSpecimen User TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage User TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty User TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart User TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription User TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing User TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod User TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter User TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation User TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction User TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask User TABLE
CollectionTask_log TABLE
CollectionTaskImage User TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric User TABLE
CollectionTaskMetric_log 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
Entity User TABLE
EntityAccessibility_Enum User TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType User TABLE
ExternalIdentifierType_log TABLE
Identification User TABLE
Identification_log TABLE
IdentificationUnit User TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis User TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod User TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter User TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis User TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart User TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User TABLE
Processing_log TABLE
ProcessingMaterialCategory User TABLE
ProjectAnalysis User TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser User TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher TABLE
Task User TABLE
Task_log TABLE
TaskDateType_Enum User TABLE
TaskModule User TABLE
TaskModule_log TABLE
TaskModuleType_Enum User TABLE
TaskResult User TABLE
TaskResult_log TABLE
TaskType_Enum User TABLE
Transaction User TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument User TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List User FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List User FUNCTION
CollEventImageType_List User FUNCTION
CollExchangeType_List User FUNCTION
CollIdentificationCategory_List User FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List User FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • User

Role CollectionManager

Role for the administration of collections and References

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis User TABLE
Analysis_log TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User User TABLE
Annotation_log TABLE
AnnotationType_Enum User TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent User TABLE
CollectionAgent_log TABLE
CollectionEvent User TABLE
CollectionEvent_log TABLE
CollectionEventImage User TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation User TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod User TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty User TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation User TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries User TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject User TABLE
CollectionProject_log TABLE
CollectionSpecimen User TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage User TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty User TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart User Storage Manager Storage Manager Storage Manager TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription User TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing User Storage Manager Storage Manager Storage Manager TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod User TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter User TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation User TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask User TABLE
CollectionTask_log TABLE
CollectionTaskImage User TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric User TABLE
CollectionTaskMetric_log 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
Entity User TABLE
EntityAccessibility_Enum User TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType User TABLE
ExternalIdentifierType_log TABLE
Identification User TABLE
Identification_log TABLE
IdentificationUnit User TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis User Storage Manager Storage Manager Storage Manager TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod User TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter User TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis User TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart User Storage Manager Storage Manager TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User TABLE
Processing_log TABLE
ProcessingMaterialCategory User TABLE
ProjectAnalysis User TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser User TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher TABLE
Task User TABLE
Task_log TABLE
TaskDateType_Enum User TABLE
TaskModule User TABLE
TaskModule_log TABLE
TaskModuleType_Enum User TABLE
TaskResult User TABLE
TaskResult_log TABLE
TaskType_Enum User TABLE
Transaction TABLE
Transaction_log TABLE
TransactionAgent Transaction User TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument TABLE
TransactionDocument_log TABLE
TransactionPayment Transaction User TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List User FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List User FUNCTION
CollEventImageType_List User FUNCTION
CollExchangeType_List User FUNCTION
CollIdentificationCategory_List User FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List User FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • StorageManager
  • TransactionUser
  • User

Role DataManager

Can insert, update and delete data from tables Analysis, Annotation, CollectionEvent, CollectionSpecimen, Method, MethodForAnalysis, MethodForProcessing, Processing, ProcessingMaterialCategory, ProjectAnalysis, ProjectProcessing

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis Editor TABLE
Analysis_log TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User TABLE
Annotation_log Editor Editor TABLE
AnnotationType_Enum User TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection Editor Editor TABLE
Collection_log Editor Editor TABLE
CollectionAgent User Editor Editor Editor TABLE
CollectionAgent_log Editor Editor TABLE
CollectionEvent User Editor Editor TABLE
CollectionEvent_log Editor Editor TABLE
CollectionEventImage User Editor Editor Editor TABLE
CollectionEventImage_log Editor Editor TABLE
CollectionEventLocalisation User Typist Typist Editor TABLE
CollectionEventLocalisation_log Typist Typist TABLE
CollectionEventMethod User TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User TABLE
CollectionEventParameterValue_log Editor Editor TABLE
CollectionEventProperty User Typist Typist Editor TABLE
CollectionEventProperty_log Typist Typist TABLE
CollectionEventRegulation User Editor Editor Editor TABLE
CollectionEventRegulation_log Editor Editor TABLE
CollectionEventSeries User Editor Typist Editor TABLE
CollectionEventSeries_log Typist Typist TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User Editor Typist Editor TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage User Editor Editor TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject User Editor Editor Editor TABLE
CollectionProject_log Editor Editor TABLE
CollectionSpecimen Typist Editor Editor TABLE
CollectionSpecimen_log Editor Editor TABLE
CollectionSpecimenImage Typist Editor Editor Editor TABLE
CollectionSpecimenImage_log Typist Typist TABLE
CollectionSpecimenImageProperty User Editor Editor Editor TABLE
CollectionSpecimenImageProperty_log Editor Editor TABLE
CollectionSpecimenPart User Typist Typist Editor TABLE
CollectionSpecimenPart_log Typist Typist TABLE
CollectionSpecimenPartDescription User Editor Editor Editor TABLE
CollectionSpecimenPartDescription_log Editor Editor TABLE
CollectionSpecimenProcessing User Editor Editor Editor TABLE
CollectionSpecimenProcessing_log Typist Typist TABLE
CollectionSpecimenProcessingMethod User Editor Editor Editor TABLE
CollectionSpecimenProcessingMethod_log Editor Editor TABLE
CollectionSpecimenProcessingMethodParameter User Editor Editor Editor TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User Editor Editor Editor TABLE
CollectionSpecimenReference_log Editor Editor TABLE
CollectionSpecimenRelation User Editor Editor Editor TABLE
CollectionSpecimenRelation_log Editor Editor TABLE
CollectionSpecimenTransaction User Typist Typist Editor TABLE
CollectionSpecimenTransaction_log Typist Typist TABLE
CollectionTask User TABLE
CollectionTask_log TABLE
CollectionTaskImage User TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric User TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum Editor TABLE
CollEventImageType_Enum Editor TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum User TABLE
CollExchangeType_Enum Editor TABLE
CollIdentificationCategory_Enum Editor TABLE
CollIdentificationDateCategory_Enum User TABLE
CollIdentificationQualifier_Enum User TABLE
CollLabelTranscriptionState_Enum User TABLE
CollLabelType_Enum Editor 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
Entity User TABLE
EntityAccessibility_Enum User TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User Editor Editor Editor TABLE
ExternalIdentifier_log Editor Editor TABLE
ExternalIdentifierType User Editor Editor Editor TABLE
ExternalIdentifierType_log Editor TABLE
Identification User Typist Typist Editor TABLE
Identification_log Editor Editor TABLE
IdentificationUnit User Editor Editor Editor TABLE
IdentificationUnit_log Editor Editor TABLE
IdentificationUnitAnalysis User Editor Editor Editor TABLE
IdentificationUnitAnalysis_log Typist Typist TABLE
IdentificationUnitAnalysisMethod User Editor Editor Editor TABLE
IdentificationUnitAnalysisMethod_log Editor Editor TABLE
IdentificationUnitAnalysisMethodParameter User Editor Editor Editor TABLE
IdentificationUnitAnalysisMethodParameter_log Editor Editor TABLE
IdentificationUnitGeoAnalysis User Editor Editor Editor TABLE
IdentificationUnitGeoAnalysis_log Editor TABLE
IdentificationUnitInPart User Typist Typist Editor TABLE
IdentificationUnitInPart_log Typist Typist TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User TABLE
Processing_log Editor TABLE
ProcessingMaterialCategory User TABLE
ProjectAnalysis User TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser User TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher Editor TABLE
Task User TABLE
Task_log TABLE
TaskDateType_Enum User TABLE
TaskModule User TABLE
TaskModule_log TABLE
TaskModuleType_Enum User TABLE
TaskResult User TABLE
TaskResult_log TABLE
TaskType_Enum User TABLE
Transaction User TABLE
Transaction_log Typist Typist TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument User Typist Typist TABLE
TransactionDocument_log Typist Typist TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString Editor FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List Editor FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List Editor FUNCTION
CollEventImageType_List Editor FUNCTION
CollExchangeType_List Editor FUNCTION
CollIdentificationCategory_List Editor FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List Editor FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr Typist FUNCTION
NextFreeAccNumber Editor FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 Editor PROCEDURE
procCopyCollectionSpecimenPart Editor PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent Editor PROCEDURE
procSetVersionCollectionSpecimen Editor PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • Editor

Role DescriptionEditor

Role with write access to the tables for the desprition of the database objects

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis TABLE
Analysis_log TABLE
AnalysisResult TABLE
AnalysisTaxonomicGroup TABLE
Annotation TABLE
Annotation_log TABLE
AnnotationType_Enum TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription TABLE
CollCircumstances_Enum TABLE
CollCollectionImageType_Enum TABLE
CollCollectionType_Enum TABLE
CollDateCategory_Enum TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent TABLE
CollectionAgent_log TABLE
CollectionEvent TABLE
CollectionEvent_log TABLE
CollectionEventImage TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject TABLE
CollectionProject_log TABLE
CollectionSpecimen TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask TABLE
CollectionTask_log TABLE
CollectionTaskImage TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum TABLE
CollEventImageType_Enum TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum TABLE
CollExchangeType_Enum TABLE
CollIdentificationCategory_Enum TABLE
CollIdentificationDateCategory_Enum TABLE
CollIdentificationQualifier_Enum TABLE
CollLabelTranscriptionState_Enum TABLE
CollLabelType_Enum TABLE
CollMaterialCategory_Enum TABLE
CollRetrievalType_Enum TABLE
CollSpecimenImageType_Enum TABLE
CollSpecimenRelationType_Enum TABLE
CollTaskMetricAggregation_Enum TABLE
CollTaxonomicGroup_Enum TABLE
CollTransactionType_Enum TABLE
CollTypeStatus_Enum TABLE
CollUnitRelationType_Enum TABLE
Entity TABLE
EntityAccessibility_Enum TABLE
EntityContext_Enum TABLE
EntityDetermination_Enum TABLE
EntityLanguageCode_Enum TABLE
EntityRepresentation TABLE
EntityUsage TABLE
EntityUsage_Enum TABLE
EntityVisibility_Enum TABLE
ExternalIdentifier TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType TABLE
ExternalIdentifierType_log TABLE
Identification TABLE
Identification_log TABLE
IdentificationUnit TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem TABLE
MeasurementUnit_Enum TABLE
Method TABLE
Method_log TABLE
MethodForAnalysis TABLE
MethodForProcessing TABLE
Parameter TABLE
Parameter_log TABLE
ParameterValue_Enum TABLE
Processing TABLE
Processing_log TABLE
ProcessingMaterialCategory TABLE
ProjectAnalysis TABLE
ProjectMaterialCategory TABLE
ProjectProcessing TABLE
ProjectTaxonomicGroup TABLE
ProjectUser TABLE
Property TABLE
PropertyType_Enum TABLE
RegulationType_Enum TABLE
ReplicationPublisher TABLE
Task TABLE
Task_log TABLE
TaskDateType_Enum TABLE
TaskModule TABLE
TaskModule_log TABLE
TaskModuleType_Enum TABLE
TaskResult TABLE
TaskResult_log TABLE
TaskType_Enum TABLE
Transaction TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment TABLE
TransactionDocument TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent VIEW
AnnotationPart VIEW
AnnotationSpecimen VIEW
AnnotationUnit VIEW
CollectionAgent_Core VIEW
CollectionEvent_Core2 VIEW
CollectionEventID_CanEdit VIEW
CollectionEventID_UserAvailable VIEW
CollectionEventLocalisation_Core VIEW
CollectionSpecimen_Core2 VIEW
CollectionSpecimenID_Available VIEW
CollectionSpecimenID_AvailableReadOnly VIEW
CollectionSpecimenID_CanEdit VIEW
CollectionSpecimenID_Locked VIEW
CollectionSpecimenID_ReadOnly VIEW
CollectionSpecimenID_UserAvailable VIEW
CollectionSpecimenPart_Core2 VIEW
CollectionSpecimenRelationInternal VIEW
CollectionSpecimenRelationInvers VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification VIEW
Identification_Core2 VIEW
IdentificationUnit_Core2 VIEW
IdentificationUnitDisplayOrder1 VIEW
ManagerSpecimenPartList VIEW
ProjectList VIEW
ProjectListNotReadOnly VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList VIEW
TransactionList_H7 VIEW
TransactionPermit VIEW
TransactionRegulation VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL VIEW
ViewCollectionEventImage VIEW
ViewCollectionEventSeriesImage VIEW
ViewCollectionImage VIEW
ViewCollectionSpecimenImage VIEW
ViewDiversityWorkbenchModule VIEW
ViewIdentificationUnitGeoAnalysis VIEW
AgentOneString FUNCTION
AnalysisChildNodes FUNCTION
AnalysisHierarchyAll FUNCTION
AnalysisList FUNCTION
AnalysisListForUnit FUNCTION
AnalysisProjectList FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL FUNCTION
CollCharacterType_List FUNCTION
CollDateCategory_List FUNCTION
CollectionChildNodes FUNCTION
CollectionEventSeriesHierarchy FUNCTION
CollectionHierarchy FUNCTION
CollectionHierarchyAll FUNCTION
CollectionHierarchyMulti FUNCTION
CollectionHierarchySuperior FUNCTION
CollectionLocation FUNCTION
CollectionLocationAll FUNCTION
CollectionLocationChildNodes FUNCTION
CollectionLocationMulti FUNCTION
CollectionLocationSuperior FUNCTION
CollectionSpecimenCoordinateList FUNCTION
CollectionSpecimenCoordinates FUNCTION
CollectionSpecimenRelationInversList FUNCTION
CollectionTaskChildNodes FUNCTION
CollectionTaskCollectionHierarchyAll FUNCTION
CollectionTaskHierarchy FUNCTION
CollectionTaskHierarchyAll FUNCTION
CollectionTaskParentNodes FUNCTION
CollEventDateCategory_List FUNCTION
CollEventImageType_List FUNCTION
CollExchangeType_List FUNCTION
CollIdentificationCategory_List FUNCTION
CollIdentificationDateCategory_List FUNCTION
CollIdentificationQualifier_List FUNCTION
CollLabelType_List FUNCTION
CollMaterialCategory_List FUNCTION
CollSpecimenImageType_List FUNCTION
CollTranscriptionState_List FUNCTION
CollTypeStatus_List FUNCTION
ColTaxonomicGroup_List FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser FUNCTION
CurrentUserName FUNCTION
DefaultProjectID FUNCTION
DiversityCollectionCacheDatabaseName FUNCTION
DiversityWorkbenchModule FUNCTION
EntityInformation_2 FUNCTION
EventDescription FUNCTION
EventDescriptionSuperior FUNCTION
EventSeriesChildNodes FUNCTION
EventSeriesHierarchy FUNCTION
EventSeriesSuperiorList FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber FUNCTION
EventSuperiorList FUNCTION
FirstLines_4 FUNCTION
FirstLinesEvent_2 FUNCTION
FirstLinesPart_2 FUNCTION
FirstLinesSeries FUNCTION
FirstLinesUnit_4 FUNCTION
LocalisationSystem_List FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes FUNCTION
MethodHierarchy FUNCTION
MethodHierarchyAll FUNCTION
NameList FUNCTION
NameListMyxomycetes FUNCTION
NameListPlants FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo FUNCTION
ProcessingChildNodes FUNCTION
ProcessingHierarchy FUNCTION
ProcessingHierarchyAll FUNCTION
ProcessingListForPart FUNCTION
ProcessingProjectList FUNCTION
ProjectDataLastChanges FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier FUNCTION
TaskChildNodes FUNCTION
TaskCollectionHierarchySeparator FUNCTION
TaskHierarchy FUNCTION
TaskHierarchyAll FUNCTION
TaskHierarchySeparator FUNCTION
TaxonWithQualifier FUNCTION
TransactionChildNodes FUNCTION
TransactionChildNodesAccess FUNCTION
TransactionCurrency FUNCTION
TransactionHierarchy FUNCTION
TransactionHierarchyAccess FUNCTION
TransactionHierarchyAll FUNCTION
UserCollectionList FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
DeleteXmlAttribute PROCEDURE
DeleteXmlNode PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute PROCEDURE
SetXmlValue PROCEDURE

Role Editor

Standard role for most users. Write permissions for most tables but can not delete data from tables CollectionReference and CollectionReference

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis TABLE
Analysis_log TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User User TABLE
Annotation_log TABLE
AnnotationType_Enum User TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent User TABLE
CollectionAgent_log TABLE
CollectionEvent User TABLE
CollectionEvent_log TABLE
CollectionEventImage User TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation User Typist Typist TABLE
CollectionEventLocalisation_log Typist Typist TABLE
CollectionEventMethod User TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty User Typist Typist TABLE
CollectionEventProperty_log Typist Typist TABLE
CollectionEventRegulation User TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries User Typist TABLE
CollectionEventSeries_log Typist Typist TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User Typist TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage User TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject User TABLE
CollectionProject_log TABLE
CollectionSpecimen Typist TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage Typist TABLE
CollectionSpecimenImage_log Typist Typist TABLE
CollectionSpecimenImageProperty User TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart User Typist Typist TABLE
CollectionSpecimenPart_log Typist Typist TABLE
CollectionSpecimenPartDescription User TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing User TABLE
CollectionSpecimenProcessing_log Typist Typist TABLE
CollectionSpecimenProcessingMethod User TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter User TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation User TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction User Typist Typist TABLE
CollectionSpecimenTransaction_log Typist Typist TABLE
CollectionTask User TABLE
CollectionTask_log TABLE
CollectionTaskImage User TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric User TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum TABLE
CollEventImageType_Enum TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum User TABLE
CollExchangeType_Enum TABLE
CollIdentificationCategory_Enum TABLE
CollIdentificationDateCategory_Enum User TABLE
CollIdentificationQualifier_Enum User TABLE
CollLabelTranscriptionState_Enum User TABLE
CollLabelType_Enum 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
Entity User TABLE
EntityAccessibility_Enum User TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType User TABLE
ExternalIdentifierType_log TABLE
Identification User Typist Typist TABLE
Identification_log TABLE
IdentificationUnit User TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis User TABLE
IdentificationUnitAnalysis_log Typist Typist TABLE
IdentificationUnitAnalysisMethod User TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter User TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis User TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart User Typist Typist TABLE
IdentificationUnitInPart_log Typist Typist TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User TABLE
Processing_log TABLE
ProcessingMaterialCategory User TABLE
ProjectAnalysis User TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser User TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher TABLE
Task User TABLE
Task_log TABLE
TaskDateType_Enum User TABLE
TaskModule User TABLE
TaskModule_log TABLE
TaskModuleType_Enum User TABLE
TaskResult User TABLE
TaskResult_log TABLE
TaskType_Enum User TABLE
Transaction User TABLE
Transaction_log Typist Typist TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument User Typist Typist TABLE
TransactionDocument_log Typist Typist TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List FUNCTION
CollEventImageType_List FUNCTION
CollExchangeType_List FUNCTION
CollIdentificationCategory_List FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr Typist FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • Typist
  • User

Role RegulationManager

Full access for tables CollectionEventRegulation and Regulation

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis TABLE
Analysis_log TABLE
AnalysisResult TABLE
AnalysisTaxonomicGroup TABLE
Annotation TABLE
Annotation_log TABLE
AnnotationType_Enum TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription TABLE
CollCircumstances_Enum TABLE
CollCollectionImageType_Enum TABLE
CollCollectionType_Enum TABLE
CollDateCategory_Enum TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent TABLE
CollectionAgent_log TABLE
CollectionEvent TABLE
CollectionEvent_log TABLE
CollectionEventImage TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject TABLE
CollectionProject_log TABLE
CollectionSpecimen TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask TABLE
CollectionTask_log TABLE
CollectionTaskImage TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum TABLE
CollEventImageType_Enum TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum TABLE
CollExchangeType_Enum TABLE
CollIdentificationCategory_Enum TABLE
CollIdentificationDateCategory_Enum TABLE
CollIdentificationQualifier_Enum TABLE
CollLabelTranscriptionState_Enum TABLE
CollLabelType_Enum TABLE
CollMaterialCategory_Enum TABLE
CollRetrievalType_Enum TABLE
CollSpecimenImageType_Enum TABLE
CollSpecimenRelationType_Enum TABLE
CollTaskMetricAggregation_Enum TABLE
CollTaxonomicGroup_Enum TABLE
CollTransactionType_Enum TABLE
CollTypeStatus_Enum TABLE
CollUnitRelationType_Enum TABLE
Entity TABLE
EntityAccessibility_Enum TABLE
EntityContext_Enum TABLE
EntityDetermination_Enum TABLE
EntityLanguageCode_Enum TABLE
EntityRepresentation TABLE
EntityUsage TABLE
EntityUsage_Enum TABLE
EntityVisibility_Enum TABLE
ExternalIdentifier TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType TABLE
ExternalIdentifierType_log TABLE
Identification TABLE
Identification_log TABLE
IdentificationUnit TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem TABLE
MeasurementUnit_Enum TABLE
Method TABLE
Method_log TABLE
MethodForAnalysis TABLE
MethodForProcessing TABLE
Parameter TABLE
Parameter_log TABLE
ParameterValue_Enum TABLE
Processing TABLE
Processing_log TABLE
ProcessingMaterialCategory TABLE
ProjectAnalysis TABLE
ProjectMaterialCategory TABLE
ProjectProcessing TABLE
ProjectTaxonomicGroup TABLE
ProjectUser TABLE
Property TABLE
PropertyType_Enum TABLE
RegulationType_Enum TABLE
ReplicationPublisher TABLE
Task TABLE
Task_log TABLE
TaskDateType_Enum TABLE
TaskModule TABLE
TaskModule_log TABLE
TaskModuleType_Enum TABLE
TaskResult TABLE
TaskResult_log TABLE
TaskType_Enum TABLE
Transaction TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment TABLE
TransactionDocument TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent VIEW
AnnotationPart VIEW
AnnotationSpecimen VIEW
AnnotationUnit VIEW
CollectionAgent_Core VIEW
CollectionEvent_Core2 VIEW
CollectionEventID_CanEdit VIEW
CollectionEventID_UserAvailable VIEW
CollectionEventLocalisation_Core VIEW
CollectionSpecimen_Core2 VIEW
CollectionSpecimenID_Available VIEW
CollectionSpecimenID_AvailableReadOnly VIEW
CollectionSpecimenID_CanEdit VIEW
CollectionSpecimenID_Locked VIEW
CollectionSpecimenID_ReadOnly VIEW
CollectionSpecimenID_UserAvailable VIEW
CollectionSpecimenPart_Core2 VIEW
CollectionSpecimenRelationInternal VIEW
CollectionSpecimenRelationInvers VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification VIEW
Identification_Core2 VIEW
IdentificationUnit_Core2 VIEW
IdentificationUnitDisplayOrder1 VIEW
ManagerSpecimenPartList VIEW
ProjectList VIEW
ProjectListNotReadOnly VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList VIEW
TransactionList_H7 VIEW
TransactionPermit VIEW
TransactionRegulation VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL VIEW
ViewCollectionEventImage VIEW
ViewCollectionEventSeriesImage VIEW
ViewCollectionImage VIEW
ViewCollectionSpecimenImage VIEW
ViewDiversityWorkbenchModule VIEW
ViewIdentificationUnitGeoAnalysis VIEW
AgentOneString FUNCTION
AnalysisChildNodes FUNCTION
AnalysisHierarchyAll FUNCTION
AnalysisList FUNCTION
AnalysisListForUnit FUNCTION
AnalysisProjectList FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL FUNCTION
CollCharacterType_List FUNCTION
CollDateCategory_List FUNCTION
CollectionChildNodes FUNCTION
CollectionEventSeriesHierarchy FUNCTION
CollectionHierarchy FUNCTION
CollectionHierarchyAll FUNCTION
CollectionHierarchyMulti FUNCTION
CollectionHierarchySuperior FUNCTION
CollectionLocation FUNCTION
CollectionLocationAll FUNCTION
CollectionLocationChildNodes FUNCTION
CollectionLocationMulti FUNCTION
CollectionLocationSuperior FUNCTION
CollectionSpecimenCoordinateList FUNCTION
CollectionSpecimenCoordinates FUNCTION
CollectionSpecimenRelationInversList FUNCTION
CollectionTaskChildNodes FUNCTION
CollectionTaskCollectionHierarchyAll FUNCTION
CollectionTaskHierarchy FUNCTION
CollectionTaskHierarchyAll FUNCTION
CollectionTaskParentNodes FUNCTION
CollEventDateCategory_List FUNCTION
CollEventImageType_List FUNCTION
CollExchangeType_List FUNCTION
CollIdentificationCategory_List FUNCTION
CollIdentificationDateCategory_List FUNCTION
CollIdentificationQualifier_List FUNCTION
CollLabelType_List FUNCTION
CollMaterialCategory_List FUNCTION
CollSpecimenImageType_List FUNCTION
CollTranscriptionState_List FUNCTION
CollTypeStatus_List FUNCTION
ColTaxonomicGroup_List FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser FUNCTION
CurrentUserName FUNCTION
DefaultProjectID FUNCTION
DiversityCollectionCacheDatabaseName FUNCTION
DiversityWorkbenchModule FUNCTION
EntityInformation_2 FUNCTION
EventDescription FUNCTION
EventDescriptionSuperior FUNCTION
EventSeriesChildNodes FUNCTION
EventSeriesHierarchy FUNCTION
EventSeriesSuperiorList FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber FUNCTION
EventSuperiorList FUNCTION
FirstLines_4 FUNCTION
FirstLinesEvent_2 FUNCTION
FirstLinesPart_2 FUNCTION
FirstLinesSeries FUNCTION
FirstLinesUnit_4 FUNCTION
LocalisationSystem_List FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes FUNCTION
MethodHierarchy FUNCTION
MethodHierarchyAll FUNCTION
NameList FUNCTION
NameListMyxomycetes FUNCTION
NameListPlants FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo FUNCTION
ProcessingChildNodes FUNCTION
ProcessingHierarchy FUNCTION
ProcessingHierarchyAll FUNCTION
ProcessingListForPart FUNCTION
ProcessingProjectList FUNCTION
ProjectDataLastChanges FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier FUNCTION
TaskChildNodes FUNCTION
TaskCollectionHierarchySeparator FUNCTION
TaskHierarchy FUNCTION
TaskHierarchyAll FUNCTION
TaskHierarchySeparator FUNCTION
TaxonWithQualifier FUNCTION
TransactionChildNodes FUNCTION
TransactionChildNodesAccess FUNCTION
TransactionCurrency FUNCTION
TransactionHierarchy FUNCTION
TransactionHierarchyAccess FUNCTION
TransactionHierarchyAll FUNCTION
UserCollectionList FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
DeleteXmlAttribute PROCEDURE
DeleteXmlNode PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute PROCEDURE
SetXmlValue PROCEDURE

Role Replicator

Role with special rights needed for replication

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis TABLE
Analysis_log TABLE
AnalysisResult TABLE
AnalysisTaxonomicGroup TABLE
Annotation TABLE
Annotation_log TABLE
AnnotationType_Enum TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription TABLE
CollCircumstances_Enum TABLE
CollCollectionImageType_Enum TABLE
CollCollectionType_Enum TABLE
CollDateCategory_Enum TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent TABLE
CollectionAgent_log TABLE
CollectionEvent TABLE
CollectionEvent_log TABLE
CollectionEventImage TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject TABLE
CollectionProject_log TABLE
CollectionSpecimen TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask TABLE
CollectionTask_log TABLE
CollectionTaskImage TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum TABLE
CollEventImageType_Enum TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum TABLE
CollExchangeType_Enum TABLE
CollIdentificationCategory_Enum TABLE
CollIdentificationDateCategory_Enum TABLE
CollIdentificationQualifier_Enum TABLE
CollLabelTranscriptionState_Enum TABLE
CollLabelType_Enum TABLE
CollMaterialCategory_Enum TABLE
CollRetrievalType_Enum TABLE
CollSpecimenImageType_Enum TABLE
CollSpecimenRelationType_Enum TABLE
CollTaskMetricAggregation_Enum TABLE
CollTaxonomicGroup_Enum TABLE
CollTransactionType_Enum TABLE
CollTypeStatus_Enum TABLE
CollUnitRelationType_Enum TABLE
Entity TABLE
EntityAccessibility_Enum TABLE
EntityContext_Enum TABLE
EntityDetermination_Enum TABLE
EntityLanguageCode_Enum TABLE
EntityRepresentation TABLE
EntityUsage TABLE
EntityUsage_Enum TABLE
EntityVisibility_Enum TABLE
ExternalIdentifier TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType TABLE
ExternalIdentifierType_log TABLE
Identification TABLE
Identification_log TABLE
IdentificationUnit TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem TABLE
MeasurementUnit_Enum TABLE
Method TABLE
Method_log TABLE
MethodForAnalysis TABLE
MethodForProcessing TABLE
Parameter TABLE
Parameter_log TABLE
ParameterValue_Enum TABLE
Processing TABLE
Processing_log TABLE
ProcessingMaterialCategory TABLE
ProjectAnalysis TABLE
ProjectMaterialCategory TABLE
ProjectProcessing TABLE
ProjectTaxonomicGroup TABLE
ProjectUser TABLE
Property TABLE
PropertyType_Enum TABLE
RegulationType_Enum TABLE
ReplicationPublisher TABLE
Task TABLE
Task_log TABLE
TaskDateType_Enum TABLE
TaskModule TABLE
TaskModule_log TABLE
TaskModuleType_Enum TABLE
TaskResult TABLE
TaskResult_log TABLE
TaskType_Enum TABLE
Transaction TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment TABLE
TransactionDocument TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent VIEW
AnnotationPart VIEW
AnnotationSpecimen VIEW
AnnotationUnit VIEW
CollectionAgent_Core VIEW
CollectionEvent_Core2 VIEW
CollectionEventID_CanEdit VIEW
CollectionEventID_UserAvailable VIEW
CollectionEventLocalisation_Core VIEW
CollectionSpecimen_Core2 VIEW
CollectionSpecimenID_Available VIEW
CollectionSpecimenID_AvailableReadOnly VIEW
CollectionSpecimenID_CanEdit VIEW
CollectionSpecimenID_Locked VIEW
CollectionSpecimenID_ReadOnly VIEW
CollectionSpecimenID_UserAvailable VIEW
CollectionSpecimenPart_Core2 VIEW
CollectionSpecimenRelationInternal VIEW
CollectionSpecimenRelationInvers VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification VIEW
Identification_Core2 VIEW
IdentificationUnit_Core2 VIEW
IdentificationUnitDisplayOrder1 VIEW
ManagerSpecimenPartList VIEW
ProjectList VIEW
ProjectListNotReadOnly VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList VIEW
TransactionList_H7 VIEW
TransactionPermit VIEW
TransactionRegulation VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL VIEW
ViewCollectionEventImage VIEW
ViewCollectionEventSeriesImage VIEW
ViewCollectionImage VIEW
ViewCollectionSpecimenImage VIEW
ViewDiversityWorkbenchModule VIEW
ViewIdentificationUnitGeoAnalysis VIEW
AgentOneString FUNCTION
AnalysisChildNodes FUNCTION
AnalysisHierarchyAll FUNCTION
AnalysisList FUNCTION
AnalysisListForUnit FUNCTION
AnalysisProjectList FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL FUNCTION
CollCharacterType_List FUNCTION
CollDateCategory_List FUNCTION
CollectionChildNodes FUNCTION
CollectionEventSeriesHierarchy FUNCTION
CollectionHierarchy FUNCTION
CollectionHierarchyAll FUNCTION
CollectionHierarchyMulti FUNCTION
CollectionHierarchySuperior FUNCTION
CollectionLocation FUNCTION
CollectionLocationAll FUNCTION
CollectionLocationChildNodes FUNCTION
CollectionLocationMulti FUNCTION
CollectionLocationSuperior FUNCTION
CollectionSpecimenCoordinateList FUNCTION
CollectionSpecimenCoordinates FUNCTION
CollectionSpecimenRelationInversList FUNCTION
CollectionTaskChildNodes FUNCTION
CollectionTaskCollectionHierarchyAll FUNCTION
CollectionTaskHierarchy FUNCTION
CollectionTaskHierarchyAll FUNCTION
CollectionTaskParentNodes FUNCTION
CollEventDateCategory_List FUNCTION
CollEventImageType_List FUNCTION
CollExchangeType_List FUNCTION
CollIdentificationCategory_List FUNCTION
CollIdentificationDateCategory_List FUNCTION
CollIdentificationQualifier_List FUNCTION
CollLabelType_List FUNCTION
CollMaterialCategory_List FUNCTION
CollSpecimenImageType_List FUNCTION
CollTranscriptionState_List FUNCTION
CollTypeStatus_List FUNCTION
ColTaxonomicGroup_List FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser FUNCTION
CurrentUserName FUNCTION
DefaultProjectID FUNCTION
DiversityCollectionCacheDatabaseName FUNCTION
DiversityWorkbenchModule FUNCTION
EntityInformation_2 FUNCTION
EventDescription FUNCTION
EventDescriptionSuperior FUNCTION
EventSeriesChildNodes FUNCTION
EventSeriesHierarchy FUNCTION
EventSeriesSuperiorList FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber FUNCTION
EventSuperiorList FUNCTION
FirstLines_4 FUNCTION
FirstLinesEvent_2 FUNCTION
FirstLinesPart_2 FUNCTION
FirstLinesSeries FUNCTION
FirstLinesUnit_4 FUNCTION
LocalisationSystem_List FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes FUNCTION
MethodHierarchy FUNCTION
MethodHierarchyAll FUNCTION
NameList FUNCTION
NameListMyxomycetes FUNCTION
NameListPlants FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo FUNCTION
ProcessingChildNodes FUNCTION
ProcessingHierarchy FUNCTION
ProcessingHierarchyAll FUNCTION
ProcessingListForPart FUNCTION
ProcessingProjectList FUNCTION
ProjectDataLastChanges FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier FUNCTION
TaskChildNodes FUNCTION
TaskCollectionHierarchySeparator FUNCTION
TaskHierarchy FUNCTION
TaskHierarchyAll FUNCTION
TaskHierarchySeparator FUNCTION
TaxonWithQualifier FUNCTION
TransactionChildNodes FUNCTION
TransactionChildNodesAccess FUNCTION
TransactionCurrency FUNCTION
TransactionHierarchy FUNCTION
TransactionHierarchyAccess FUNCTION
TransactionHierarchyAll FUNCTION
UserCollectionList FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
DeleteXmlAttribute PROCEDURE
DeleteXmlNode PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute PROCEDURE
SetXmlValue PROCEDURE

Role Requester

Role with the permission to place requests for loans

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis TABLE
Analysis_log TABLE
AnalysisResult TABLE
AnalysisTaxonomicGroup TABLE
Annotation TABLE
Annotation_log TABLE
AnnotationType_Enum TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription TABLE
CollCircumstances_Enum TABLE
CollCollectionImageType_Enum TABLE
CollCollectionType_Enum TABLE
CollDateCategory_Enum TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent TABLE
CollectionAgent_log TABLE
CollectionEvent TABLE
CollectionEvent_log TABLE
CollectionEventImage TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject TABLE
CollectionProject_log TABLE
CollectionSpecimen TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask TABLE
CollectionTask_log TABLE
CollectionTaskImage TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum TABLE
CollEventImageType_Enum TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum TABLE
CollExchangeType_Enum TABLE
CollIdentificationCategory_Enum TABLE
CollIdentificationDateCategory_Enum TABLE
CollIdentificationQualifier_Enum TABLE
CollLabelTranscriptionState_Enum TABLE
CollLabelType_Enum TABLE
CollMaterialCategory_Enum TABLE
CollRetrievalType_Enum TABLE
CollSpecimenImageType_Enum TABLE
CollSpecimenRelationType_Enum TABLE
CollTaskMetricAggregation_Enum TABLE
CollTaxonomicGroup_Enum TABLE
CollTransactionType_Enum TABLE
CollTypeStatus_Enum TABLE
CollUnitRelationType_Enum TABLE
Entity TABLE
EntityAccessibility_Enum TABLE
EntityContext_Enum TABLE
EntityDetermination_Enum TABLE
EntityLanguageCode_Enum TABLE
EntityRepresentation TABLE
EntityUsage TABLE
EntityUsage_Enum TABLE
EntityVisibility_Enum TABLE
ExternalIdentifier TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType TABLE
ExternalIdentifierType_log TABLE
Identification TABLE
Identification_log TABLE
IdentificationUnit TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem TABLE
MeasurementUnit_Enum TABLE
Method TABLE
Method_log TABLE
MethodForAnalysis TABLE
MethodForProcessing TABLE
Parameter TABLE
Parameter_log TABLE
ParameterValue_Enum TABLE
Processing TABLE
Processing_log TABLE
ProcessingMaterialCategory TABLE
ProjectAnalysis TABLE
ProjectMaterialCategory TABLE
ProjectProcessing TABLE
ProjectTaxonomicGroup TABLE
ProjectUser TABLE
Property TABLE
PropertyType_Enum TABLE
RegulationType_Enum TABLE
ReplicationPublisher TABLE
Task TABLE
Task_log TABLE
TaskDateType_Enum TABLE
TaskModule TABLE
TaskModule_log TABLE
TaskModuleType_Enum TABLE
TaskResult TABLE
TaskResult_log TABLE
TaskType_Enum TABLE
Transaction TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment TABLE
TransactionDocument TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent VIEW
AnnotationPart VIEW
AnnotationSpecimen VIEW
AnnotationUnit VIEW
CollectionAgent_Core VIEW
CollectionEvent_Core2 VIEW
CollectionEventID_CanEdit VIEW
CollectionEventID_UserAvailable VIEW
CollectionEventLocalisation_Core VIEW
CollectionSpecimen_Core2 VIEW
CollectionSpecimenID_Available VIEW
CollectionSpecimenID_AvailableReadOnly VIEW
CollectionSpecimenID_CanEdit VIEW
CollectionSpecimenID_Locked VIEW
CollectionSpecimenID_ReadOnly VIEW
CollectionSpecimenID_UserAvailable VIEW
CollectionSpecimenPart_Core2 VIEW
CollectionSpecimenRelationInternal VIEW
CollectionSpecimenRelationInvers VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification VIEW
Identification_Core2 VIEW
IdentificationUnit_Core2 VIEW
IdentificationUnitDisplayOrder1 VIEW
ManagerSpecimenPartList VIEW
ProjectList VIEW
ProjectListNotReadOnly VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList VIEW
TransactionList_H7 VIEW
TransactionPermit VIEW
TransactionRegulation VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL VIEW
ViewCollectionEventImage VIEW
ViewCollectionEventSeriesImage VIEW
ViewCollectionImage VIEW
ViewCollectionSpecimenImage VIEW
ViewDiversityWorkbenchModule VIEW
ViewIdentificationUnitGeoAnalysis VIEW
AgentOneString FUNCTION
AnalysisChildNodes FUNCTION
AnalysisHierarchyAll FUNCTION
AnalysisList FUNCTION
AnalysisListForUnit FUNCTION
AnalysisProjectList FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL FUNCTION
CollCharacterType_List FUNCTION
CollDateCategory_List FUNCTION
CollectionChildNodes FUNCTION
CollectionEventSeriesHierarchy FUNCTION
CollectionHierarchy FUNCTION
CollectionHierarchyAll FUNCTION
CollectionHierarchyMulti FUNCTION
CollectionHierarchySuperior FUNCTION
CollectionLocation FUNCTION
CollectionLocationAll FUNCTION
CollectionLocationChildNodes FUNCTION
CollectionLocationMulti FUNCTION
CollectionLocationSuperior FUNCTION
CollectionSpecimenCoordinateList FUNCTION
CollectionSpecimenCoordinates FUNCTION
CollectionSpecimenRelationInversList FUNCTION
CollectionTaskChildNodes FUNCTION
CollectionTaskCollectionHierarchyAll FUNCTION
CollectionTaskHierarchy FUNCTION
CollectionTaskHierarchyAll FUNCTION
CollectionTaskParentNodes FUNCTION
CollEventDateCategory_List FUNCTION
CollEventImageType_List FUNCTION
CollExchangeType_List FUNCTION
CollIdentificationCategory_List FUNCTION
CollIdentificationDateCategory_List FUNCTION
CollIdentificationQualifier_List FUNCTION
CollLabelType_List FUNCTION
CollMaterialCategory_List FUNCTION
CollSpecimenImageType_List FUNCTION
CollTranscriptionState_List FUNCTION
CollTypeStatus_List FUNCTION
ColTaxonomicGroup_List FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser FUNCTION
CurrentUserName FUNCTION
DefaultProjectID FUNCTION
DiversityCollectionCacheDatabaseName FUNCTION
DiversityWorkbenchModule FUNCTION
EntityInformation_2 FUNCTION
EventDescription FUNCTION
EventDescriptionSuperior FUNCTION
EventSeriesChildNodes FUNCTION
EventSeriesHierarchy FUNCTION
EventSeriesSuperiorList FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber FUNCTION
EventSuperiorList FUNCTION
FirstLines_4 FUNCTION
FirstLinesEvent_2 FUNCTION
FirstLinesPart_2 FUNCTION
FirstLinesSeries FUNCTION
FirstLinesUnit_4 FUNCTION
LocalisationSystem_List FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes FUNCTION
MethodHierarchy FUNCTION
MethodHierarchyAll FUNCTION
NameList FUNCTION
NameListMyxomycetes FUNCTION
NameListPlants FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo FUNCTION
ProcessingChildNodes FUNCTION
ProcessingHierarchy FUNCTION
ProcessingHierarchyAll FUNCTION
ProcessingListForPart FUNCTION
ProcessingProjectList FUNCTION
ProjectDataLastChanges FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier FUNCTION
TaskChildNodes FUNCTION
TaskCollectionHierarchySeparator FUNCTION
TaskHierarchy FUNCTION
TaskHierarchyAll FUNCTION
TaskHierarchySeparator FUNCTION
TaxonWithQualifier FUNCTION
TransactionChildNodes FUNCTION
TransactionChildNodesAccess FUNCTION
TransactionCurrency FUNCTION
TransactionHierarchy FUNCTION
TransactionHierarchyAccess FUNCTION
TransactionHierarchyAll FUNCTION
UserCollectionList FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
DeleteXmlAttribute PROCEDURE
DeleteXmlNode PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute PROCEDURE
SetXmlValue PROCEDURE

Role StorageManager

Role for handling Reference References and related information

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis User TABLE
Analysis_log TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User User TABLE
Annotation_log TABLE
AnnotationType_Enum User TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection User TABLE
Collection_log TABLE
CollectionAgent User TABLE
CollectionAgent_log TABLE
CollectionEvent User TABLE
CollectionEvent_log TABLE
CollectionEventImage User TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation User TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod User TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty User TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation User TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries User TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage User TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject User TABLE
CollectionProject_log TABLE
CollectionSpecimen User TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage User TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty User TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart User TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription User TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing User TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod User TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter User TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation User TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction User TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask User TABLE
CollectionTask_log TABLE
CollectionTaskImage User TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric User TABLE
CollectionTaskMetric_log 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
Entity User TABLE
EntityAccessibility_Enum User TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType User TABLE
ExternalIdentifierType_log TABLE
Identification User TABLE
Identification_log TABLE
IdentificationUnit User TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis User TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod User TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter User TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis User TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart User TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User TABLE
Processing_log TABLE
ProcessingMaterialCategory User TABLE
ProjectAnalysis User TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser User TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher TABLE
Task User TABLE
Task_log TABLE
TaskDateType_Enum User TABLE
TaskModule User TABLE
TaskModule_log TABLE
TaskModuleType_Enum User TABLE
TaskResult User TABLE
TaskResult_log TABLE
TaskType_Enum User TABLE
Transaction User TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument User TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List User FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List User FUNCTION
CollEventImageType_List User FUNCTION
CollExchangeType_List User FUNCTION
CollIdentificationCategory_List User FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List User FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • User

Role TransactionUser

Database Role with reading accesss to Transaction information.

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis TABLE
Analysis_log TABLE
AnalysisResult TABLE
AnalysisTaxonomicGroup TABLE
Annotation TABLE
Annotation_log TABLE
AnnotationType_Enum TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription TABLE
CollCircumstances_Enum TABLE
CollCollectionImageType_Enum TABLE
CollCollectionType_Enum TABLE
CollDateCategory_Enum TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent TABLE
CollectionAgent_log TABLE
CollectionEvent TABLE
CollectionEvent_log TABLE
CollectionEventImage TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject TABLE
CollectionProject_log TABLE
CollectionSpecimen TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask TABLE
CollectionTask_log TABLE
CollectionTaskImage TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum TABLE
CollEventImageType_Enum TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum TABLE
CollExchangeType_Enum TABLE
CollIdentificationCategory_Enum TABLE
CollIdentificationDateCategory_Enum TABLE
CollIdentificationQualifier_Enum TABLE
CollLabelTranscriptionState_Enum TABLE
CollLabelType_Enum TABLE
CollMaterialCategory_Enum TABLE
CollRetrievalType_Enum TABLE
CollSpecimenImageType_Enum TABLE
CollSpecimenRelationType_Enum TABLE
CollTaskMetricAggregation_Enum TABLE
CollTaxonomicGroup_Enum TABLE
CollTransactionType_Enum TABLE
CollTypeStatus_Enum TABLE
CollUnitRelationType_Enum TABLE
Entity TABLE
EntityAccessibility_Enum TABLE
EntityContext_Enum TABLE
EntityDetermination_Enum TABLE
EntityLanguageCode_Enum TABLE
EntityRepresentation TABLE
EntityUsage TABLE
EntityUsage_Enum TABLE
EntityVisibility_Enum TABLE
ExternalIdentifier TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType TABLE
ExternalIdentifierType_log TABLE
Identification TABLE
Identification_log TABLE
IdentificationUnit TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem TABLE
MeasurementUnit_Enum TABLE
Method TABLE
Method_log TABLE
MethodForAnalysis TABLE
MethodForProcessing TABLE
Parameter TABLE
Parameter_log TABLE
ParameterValue_Enum TABLE
Processing TABLE
Processing_log TABLE
ProcessingMaterialCategory TABLE
ProjectAnalysis TABLE
ProjectMaterialCategory TABLE
ProjectProcessing TABLE
ProjectTaxonomicGroup TABLE
ProjectUser TABLE
Property TABLE
PropertyType_Enum TABLE
RegulationType_Enum TABLE
ReplicationPublisher TABLE
Task TABLE
Task_log TABLE
TaskDateType_Enum TABLE
TaskModule TABLE
TaskModule_log TABLE
TaskModuleType_Enum TABLE
TaskResult TABLE
TaskResult_log TABLE
TaskType_Enum TABLE
Transaction TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment TABLE
TransactionDocument TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent VIEW
AnnotationPart VIEW
AnnotationSpecimen VIEW
AnnotationUnit VIEW
CollectionAgent_Core VIEW
CollectionEvent_Core2 VIEW
CollectionEventID_CanEdit VIEW
CollectionEventID_UserAvailable VIEW
CollectionEventLocalisation_Core VIEW
CollectionSpecimen_Core2 VIEW
CollectionSpecimenID_Available VIEW
CollectionSpecimenID_AvailableReadOnly VIEW
CollectionSpecimenID_CanEdit VIEW
CollectionSpecimenID_Locked VIEW
CollectionSpecimenID_ReadOnly VIEW
CollectionSpecimenID_UserAvailable VIEW
CollectionSpecimenPart_Core2 VIEW
CollectionSpecimenRelationInternal VIEW
CollectionSpecimenRelationInvers VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification VIEW
Identification_Core2 VIEW
IdentificationUnit_Core2 VIEW
IdentificationUnitDisplayOrder1 VIEW
ManagerSpecimenPartList VIEW
ProjectList VIEW
ProjectListNotReadOnly VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList VIEW
TransactionList_H7 VIEW
TransactionPermit VIEW
TransactionRegulation VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL VIEW
ViewCollectionEventImage VIEW
ViewCollectionEventSeriesImage VIEW
ViewCollectionImage VIEW
ViewCollectionSpecimenImage VIEW
ViewDiversityWorkbenchModule VIEW
ViewIdentificationUnitGeoAnalysis VIEW
AgentOneString FUNCTION
AnalysisChildNodes FUNCTION
AnalysisHierarchyAll FUNCTION
AnalysisList FUNCTION
AnalysisListForUnit FUNCTION
AnalysisProjectList FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL FUNCTION
CollCharacterType_List FUNCTION
CollDateCategory_List FUNCTION
CollectionChildNodes FUNCTION
CollectionEventSeriesHierarchy FUNCTION
CollectionHierarchy FUNCTION
CollectionHierarchyAll FUNCTION
CollectionHierarchyMulti FUNCTION
CollectionHierarchySuperior FUNCTION
CollectionLocation FUNCTION
CollectionLocationAll FUNCTION
CollectionLocationChildNodes FUNCTION
CollectionLocationMulti FUNCTION
CollectionLocationSuperior FUNCTION
CollectionSpecimenCoordinateList FUNCTION
CollectionSpecimenCoordinates FUNCTION
CollectionSpecimenRelationInversList FUNCTION
CollectionTaskChildNodes FUNCTION
CollectionTaskCollectionHierarchyAll FUNCTION
CollectionTaskHierarchy FUNCTION
CollectionTaskHierarchyAll FUNCTION
CollectionTaskParentNodes FUNCTION
CollEventDateCategory_List FUNCTION
CollEventImageType_List FUNCTION
CollExchangeType_List FUNCTION
CollIdentificationCategory_List FUNCTION
CollIdentificationDateCategory_List FUNCTION
CollIdentificationQualifier_List FUNCTION
CollLabelType_List FUNCTION
CollMaterialCategory_List FUNCTION
CollSpecimenImageType_List FUNCTION
CollTranscriptionState_List FUNCTION
CollTypeStatus_List FUNCTION
ColTaxonomicGroup_List FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser FUNCTION
CurrentUserName FUNCTION
DefaultProjectID FUNCTION
DiversityCollectionCacheDatabaseName FUNCTION
DiversityWorkbenchModule FUNCTION
EntityInformation_2 FUNCTION
EventDescription FUNCTION
EventDescriptionSuperior FUNCTION
EventSeriesChildNodes FUNCTION
EventSeriesHierarchy FUNCTION
EventSeriesSuperiorList FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber FUNCTION
EventSuperiorList FUNCTION
FirstLines_4 FUNCTION
FirstLinesEvent_2 FUNCTION
FirstLinesPart_2 FUNCTION
FirstLinesSeries FUNCTION
FirstLinesUnit_4 FUNCTION
LocalisationSystem_List FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes FUNCTION
MethodHierarchy FUNCTION
MethodHierarchyAll FUNCTION
NameList FUNCTION
NameListMyxomycetes FUNCTION
NameListPlants FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo FUNCTION
ProcessingChildNodes FUNCTION
ProcessingHierarchy FUNCTION
ProcessingHierarchyAll FUNCTION
ProcessingListForPart FUNCTION
ProcessingProjectList FUNCTION
ProjectDataLastChanges FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier FUNCTION
TaskChildNodes FUNCTION
TaskCollectionHierarchySeparator FUNCTION
TaskHierarchy FUNCTION
TaskHierarchyAll FUNCTION
TaskHierarchySeparator FUNCTION
TaxonWithQualifier FUNCTION
TransactionChildNodes FUNCTION
TransactionChildNodesAccess FUNCTION
TransactionCurrency FUNCTION
TransactionHierarchy FUNCTION
TransactionHierarchyAccess FUNCTION
TransactionHierarchyAll FUNCTION
UserCollectionList FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
DeleteXmlAttribute PROCEDURE
DeleteXmlNode PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute PROCEDURE
SetXmlValue PROCEDURE

Role Typist

Write access to most objects. Can not delete data and not insert data into tables CollectionReference and CollectionReference

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis User TABLE
Analysis_log TABLE
AnalysisResult User TABLE
AnalysisTaxonomicGroup User TABLE
Annotation User User User TABLE
Annotation_log TABLE
AnnotationType_Enum User TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription User User User User TABLE
CollCircumstances_Enum User TABLE
CollCollectionImageType_Enum User TABLE
CollCollectionType_Enum User TABLE
CollDateCategory_Enum User TABLE
Collection User TABLE
Collection_log TABLE
CollectionAgent User TABLE
CollectionAgent_log TABLE
CollectionEvent User TABLE
CollectionEvent_log TABLE
CollectionEventImage User TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation User TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod User TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue User TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty User TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation User TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries User TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage User TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource User TABLE
CollectionExternalDatasource_log TABLE
CollectionImage User TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject User TABLE
CollectionProject_log TABLE
CollectionSpecimen TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty User TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart User TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription User TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing User TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod User TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter User TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference User TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation User TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction User TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask User TABLE
CollectionTask_log TABLE
CollectionTaskImage User TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric User TABLE
CollectionTaskMetric_log 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
Entity User TABLE
EntityAccessibility_Enum User TABLE
EntityContext_Enum User TABLE
EntityDetermination_Enum User TABLE
EntityLanguageCode_Enum User TABLE
EntityRepresentation User TABLE
EntityUsage User TABLE
EntityUsage_Enum User TABLE
EntityVisibility_Enum User TABLE
ExternalIdentifier User TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType User TABLE
ExternalIdentifierType_log TABLE
Identification User TABLE
Identification_log TABLE
IdentificationUnit User TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis User TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod User TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter User TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis User TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart User TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem User TABLE
MeasurementUnit_Enum TABLE
Method User TABLE
Method_log TABLE
MethodForAnalysis User TABLE
MethodForProcessing User TABLE
Parameter User TABLE
Parameter_log TABLE
ParameterValue_Enum User TABLE
Processing User TABLE
Processing_log TABLE
ProcessingMaterialCategory User TABLE
ProjectAnalysis User TABLE
ProjectMaterialCategory User TABLE
ProjectProcessing User TABLE
ProjectTaxonomicGroup User TABLE
ProjectUser User TABLE
Property User TABLE
PropertyType_Enum TABLE
RegulationType_Enum User TABLE
ReplicationPublisher TABLE
Task User TABLE
Task_log TABLE
TaskDateType_Enum User TABLE
TaskModule User TABLE
TaskModule_log TABLE
TaskModuleType_Enum User TABLE
TaskResult User TABLE
TaskResult_log TABLE
TaskType_Enum User TABLE
Transaction User TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment User TABLE
TransactionDocument User TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent User VIEW
AnnotationPart User VIEW
AnnotationSpecimen User VIEW
AnnotationUnit User VIEW
CollectionAgent_Core User VIEW
CollectionEvent_Core2 User VIEW
CollectionEventID_CanEdit User VIEW
CollectionEventID_UserAvailable User VIEW
CollectionEventLocalisation_Core User VIEW
CollectionSpecimen_Core2 User VIEW
CollectionSpecimenID_Available User VIEW
CollectionSpecimenID_AvailableReadOnly User VIEW
CollectionSpecimenID_CanEdit User VIEW
CollectionSpecimenID_Locked User VIEW
CollectionSpecimenID_ReadOnly User VIEW
CollectionSpecimenID_UserAvailable User VIEW
CollectionSpecimenPart_Core2 User VIEW
CollectionSpecimenRelationInternal User VIEW
CollectionSpecimenRelationInvers User VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification User VIEW
Identification_Core2 User VIEW
IdentificationUnit_Core2 User VIEW
IdentificationUnitDisplayOrder1 User VIEW
ManagerSpecimenPartList VIEW
ProjectList User VIEW
ProjectListNotReadOnly User VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList User VIEW
TransactionList_H7 User VIEW
TransactionPermit User VIEW
TransactionRegulation User VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL User VIEW
ViewCollectionEventImage User VIEW
ViewCollectionEventSeriesImage User VIEW
ViewCollectionImage User VIEW
ViewCollectionSpecimenImage User VIEW
ViewDiversityWorkbenchModule User VIEW
ViewIdentificationUnitGeoAnalysis User VIEW
AgentOneString FUNCTION
AnalysisChildNodes User FUNCTION
AnalysisHierarchyAll User FUNCTION
AnalysisList User FUNCTION
AnalysisListForUnit User FUNCTION
AnalysisProjectList User FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL User FUNCTION
CollCharacterType_List User FUNCTION
CollDateCategory_List User FUNCTION
CollectionChildNodes User FUNCTION
CollectionEventSeriesHierarchy User FUNCTION
CollectionHierarchy User FUNCTION
CollectionHierarchyAll User FUNCTION
CollectionHierarchyMulti User FUNCTION
CollectionHierarchySuperior User FUNCTION
CollectionLocation User FUNCTION
CollectionLocationAll User FUNCTION
CollectionLocationChildNodes User FUNCTION
CollectionLocationMulti User FUNCTION
CollectionLocationSuperior User FUNCTION
CollectionSpecimenCoordinateList User FUNCTION
CollectionSpecimenCoordinates User FUNCTION
CollectionSpecimenRelationInversList User FUNCTION
CollectionTaskChildNodes User FUNCTION
CollectionTaskCollectionHierarchyAll User FUNCTION
CollectionTaskHierarchy User FUNCTION
CollectionTaskHierarchyAll User FUNCTION
CollectionTaskParentNodes User FUNCTION
CollEventDateCategory_List User FUNCTION
CollEventImageType_List User FUNCTION
CollExchangeType_List User FUNCTION
CollIdentificationCategory_List User FUNCTION
CollIdentificationDateCategory_List User FUNCTION
CollIdentificationQualifier_List User FUNCTION
CollLabelType_List User FUNCTION
CollMaterialCategory_List User FUNCTION
CollSpecimenImageType_List User FUNCTION
CollTranscriptionState_List User FUNCTION
CollTypeStatus_List User FUNCTION
ColTaxonomicGroup_List User FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser User FUNCTION
CurrentUserName User FUNCTION
DefaultProjectID User FUNCTION
DiversityCollectionCacheDatabaseName User FUNCTION
DiversityWorkbenchModule User FUNCTION
EntityInformation_2 User FUNCTION
EventDescription User FUNCTION
EventDescriptionSuperior User FUNCTION
EventSeriesChildNodes User FUNCTION
EventSeriesHierarchy User FUNCTION
EventSeriesSuperiorList User FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber User FUNCTION
EventSuperiorList User FUNCTION
FirstLines_4 User FUNCTION
FirstLinesEvent_2 User FUNCTION
FirstLinesPart_2 User FUNCTION
FirstLinesSeries User FUNCTION
FirstLinesUnit_4 User FUNCTION
LocalisationSystem_List User FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes User FUNCTION
MethodHierarchy User FUNCTION
MethodHierarchyAll User FUNCTION
NameList User FUNCTION
NameListMyxomycetes User FUNCTION
NameListPlants User FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo User FUNCTION
ProcessingChildNodes User FUNCTION
ProcessingHierarchy User FUNCTION
ProcessingHierarchyAll User FUNCTION
ProcessingListForPart User FUNCTION
ProcessingProjectList User FUNCTION
ProjectDataLastChanges User FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier User FUNCTION
TaskChildNodes User FUNCTION
TaskCollectionHierarchySeparator User FUNCTION
TaskHierarchy User FUNCTION
TaskHierarchyAll User FUNCTION
TaskHierarchySeparator User FUNCTION
TaxonWithQualifier User FUNCTION
TransactionChildNodes User FUNCTION
TransactionChildNodesAccess User FUNCTION
TransactionCurrency User FUNCTION
TransactionHierarchy User FUNCTION
TransactionHierarchyAccess User FUNCTION
TransactionHierarchyAll User FUNCTION
UserCollectionList User FUNCTION
UserID User FUNCTION
Version User FUNCTION
VersionClient User FUNCTION
DeleteXmlAttribute User PROCEDURE
DeleteXmlNode User PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription User PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute User PROCEDURE
SetXmlValue User PROCEDURE
Inheriting from roles:
  • User

Role User

Restricted to read access to all tables. Can insert data into table Annotation

Permissions SELECT INSERT UPDATE DELETE EXECUTE Type
Analysis TABLE
Analysis_log TABLE
AnalysisResult TABLE
AnalysisTaxonomicGroup TABLE
Annotation TABLE
Annotation_log TABLE
AnnotationType_Enum TABLE
AnonymCollector TABLE
CacheDatabase2 TABLE
CacheDescription TABLE
CollCircumstances_Enum TABLE
CollCollectionImageType_Enum TABLE
CollCollectionType_Enum TABLE
CollDateCategory_Enum TABLE
Collection TABLE
Collection_log TABLE
CollectionAgent TABLE
CollectionAgent_log TABLE
CollectionEvent TABLE
CollectionEvent_log TABLE
CollectionEventImage TABLE
CollectionEventImage_log TABLE
CollectionEventLocalisation TABLE
CollectionEventLocalisation_log TABLE
CollectionEventMethod TABLE
CollectionEventMethod_log TABLE
CollectionEventParameterValue TABLE
CollectionEventParameterValue_log TABLE
CollectionEventProperty TABLE
CollectionEventProperty_log TABLE
CollectionEventRegulation TABLE
CollectionEventRegulation_log TABLE
CollectionEventSeries TABLE
CollectionEventSeries_log TABLE
CollectionEventSeriesDescriptor TABLE
CollectionEventSeriesDescriptor_log TABLE
CollectionEventSeriesImage TABLE
CollectionEventSeriesImage_log TABLE
CollectionExternalDatasource TABLE
CollectionExternalDatasource_log TABLE
CollectionImage TABLE
CollectionImage_log TABLE
CollectionManager TABLE
CollectionProject TABLE
CollectionProject_log TABLE
CollectionSpecimen TABLE
CollectionSpecimen_log TABLE
CollectionSpecimenImage TABLE
CollectionSpecimenImage_log TABLE
CollectionSpecimenImageProperty TABLE
CollectionSpecimenImageProperty_log TABLE
CollectionSpecimenPart TABLE
CollectionSpecimenPart_log TABLE
CollectionSpecimenPartDescription TABLE
CollectionSpecimenPartDescription_log TABLE
CollectionSpecimenProcessing TABLE
CollectionSpecimenProcessing_log TABLE
CollectionSpecimenProcessingMethod TABLE
CollectionSpecimenProcessingMethod_log TABLE
CollectionSpecimenProcessingMethodParameter TABLE
CollectionSpecimenProcessingMethodParameter_log TABLE
CollectionSpecimenReference TABLE
CollectionSpecimenReference_log TABLE
CollectionSpecimenRelation TABLE
CollectionSpecimenRelation_log TABLE
CollectionSpecimenTransaction TABLE
CollectionSpecimenTransaction_log TABLE
CollectionTask TABLE
CollectionTask_log TABLE
CollectionTaskImage TABLE
CollectionTaskImage_log TABLE
CollectionTaskMetric TABLE
CollectionTaskMetric_log TABLE
CollEventDateCategory_Enum TABLE
CollEventImageType_Enum TABLE
CollEventSeriesDescriptorType_Enum TABLE
CollEventSeriesImageType_Enum TABLE
CollExchangeType_Enum TABLE
CollIdentificationCategory_Enum TABLE
CollIdentificationDateCategory_Enum TABLE
CollIdentificationQualifier_Enum TABLE
CollLabelTranscriptionState_Enum TABLE
CollLabelType_Enum TABLE
CollMaterialCategory_Enum TABLE
CollRetrievalType_Enum TABLE
CollSpecimenImageType_Enum TABLE
CollSpecimenRelationType_Enum TABLE
CollTaskMetricAggregation_Enum TABLE
CollTaxonomicGroup_Enum TABLE
CollTransactionType_Enum TABLE
CollTypeStatus_Enum TABLE
CollUnitRelationType_Enum TABLE
Entity TABLE
EntityAccessibility_Enum TABLE
EntityContext_Enum TABLE
EntityDetermination_Enum TABLE
EntityLanguageCode_Enum TABLE
EntityRepresentation TABLE
EntityUsage TABLE
EntityUsage_Enum TABLE
EntityVisibility_Enum TABLE
ExternalIdentifier TABLE
ExternalIdentifier_log TABLE
ExternalIdentifierType TABLE
ExternalIdentifierType_log TABLE
Identification TABLE
Identification_log TABLE
IdentificationUnit TABLE
IdentificationUnit_log TABLE
IdentificationUnitAnalysis TABLE
IdentificationUnitAnalysis_log TABLE
IdentificationUnitAnalysisMethod TABLE
IdentificationUnitAnalysisMethod_log TABLE
IdentificationUnitAnalysisMethodParameter TABLE
IdentificationUnitAnalysisMethodParameter_log TABLE
IdentificationUnitGeoAnalysis TABLE
IdentificationUnitGeoAnalysis_log TABLE
IdentificationUnitInPart TABLE
IdentificationUnitInPart_log TABLE
LanguageCode_Enum TABLE
LocalisationSystem TABLE
MeasurementUnit_Enum TABLE
Method TABLE
Method_log TABLE
MethodForAnalysis TABLE
MethodForProcessing TABLE
Parameter TABLE
Parameter_log TABLE
ParameterValue_Enum TABLE
Processing TABLE
Processing_log TABLE
ProcessingMaterialCategory TABLE
ProjectAnalysis TABLE
ProjectMaterialCategory TABLE
ProjectProcessing TABLE
ProjectTaxonomicGroup TABLE
ProjectUser TABLE
Property TABLE
PropertyType_Enum TABLE
RegulationType_Enum TABLE
ReplicationPublisher TABLE
Task TABLE
Task_log TABLE
TaskDateType_Enum TABLE
TaskModule TABLE
TaskModule_log TABLE
TaskModuleType_Enum TABLE
TaskResult TABLE
TaskResult_log TABLE
TaskType_Enum TABLE
Transaction TABLE
Transaction_log TABLE
TransactionAgent TABLE
TransactionAgent_log TABLE
TransactionComment TABLE
TransactionDocument TABLE
TransactionDocument_log TABLE
TransactionPayment TABLE
TransactionPayment_log TABLE
AnnotationEvent VIEW
AnnotationPart VIEW
AnnotationSpecimen VIEW
AnnotationUnit VIEW
CollectionAgent_Core VIEW
CollectionEvent_Core2 VIEW
CollectionEventID_CanEdit VIEW
CollectionEventID_UserAvailable VIEW
CollectionEventLocalisation_Core VIEW
CollectionSpecimen_Core2 VIEW
CollectionSpecimenID_Available VIEW
CollectionSpecimenID_AvailableReadOnly VIEW
CollectionSpecimenID_CanEdit VIEW
CollectionSpecimenID_Locked VIEW
CollectionSpecimenID_ReadOnly VIEW
CollectionSpecimenID_UserAvailable VIEW
CollectionSpecimenPart_Core2 VIEW
CollectionSpecimenRelationInternal VIEW
CollectionSpecimenRelationInvers VIEW
CollectionSpecimenTransactionRequest VIEW
FirstLinesIdentification VIEW
Identification_Core2 VIEW
IdentificationUnit_Core2 VIEW
IdentificationUnitDisplayOrder1 VIEW
ManagerSpecimenPartList VIEW
ProjectList VIEW
ProjectListNotReadOnly VIEW
RequesterSpecimenPartList VIEW
TransactionForeignRequest VIEW
TransactionList VIEW
TransactionList_H7 VIEW
TransactionPermit VIEW
TransactionRegulation VIEW
TransactionRequest VIEW
TransactionUserRequest VIEW
UserGroups VIEW
ViewBaseURL VIEW
ViewCollectionEventImage VIEW
ViewCollectionEventSeriesImage VIEW
ViewCollectionImage VIEW
ViewCollectionSpecimenImage VIEW
ViewDiversityWorkbenchModule VIEW
ViewIdentificationUnitGeoAnalysis VIEW
AgentOneString FUNCTION
AnalysisChildNodes FUNCTION
AnalysisHierarchyAll FUNCTION
AnalysisList FUNCTION
AnalysisListForUnit FUNCTION
AnalysisProjectList FUNCTION
AnalysisTaxonomicGroupForProject FUNCTION
AverageAltitude FUNCTION
BaseURL FUNCTION
CollCharacterType_List FUNCTION
CollDateCategory_List FUNCTION
CollectionChildNodes FUNCTION
CollectionEventSeriesHierarchy FUNCTION
CollectionHierarchy FUNCTION
CollectionHierarchyAll FUNCTION
CollectionHierarchyMulti FUNCTION
CollectionHierarchySuperior FUNCTION
CollectionLocation FUNCTION
CollectionLocationAll FUNCTION
CollectionLocationChildNodes FUNCTION
CollectionLocationMulti FUNCTION
CollectionLocationSuperior FUNCTION
CollectionSpecimenCoordinateList FUNCTION
CollectionSpecimenCoordinates FUNCTION
CollectionSpecimenRelationInversList FUNCTION
CollectionTaskChildNodes FUNCTION
CollectionTaskCollectionHierarchyAll FUNCTION
CollectionTaskHierarchy FUNCTION
CollectionTaskHierarchyAll FUNCTION
CollectionTaskParentNodes FUNCTION
CollEventDateCategory_List FUNCTION
CollEventImageType_List FUNCTION
CollExchangeType_List FUNCTION
CollIdentificationCategory_List FUNCTION
CollIdentificationDateCategory_List FUNCTION
CollIdentificationQualifier_List FUNCTION
CollLabelType_List FUNCTION
CollMaterialCategory_List FUNCTION
CollSpecimenImageType_List FUNCTION
CollTranscriptionState_List FUNCTION
CollTypeStatus_List FUNCTION
ColTaxonomicGroup_List FUNCTION
CuratorCollectionHierarchyList FUNCTION
CurrentUser FUNCTION
CurrentUserName FUNCTION
DefaultProjectID FUNCTION
DiversityCollectionCacheDatabaseName FUNCTION
DiversityWorkbenchModule FUNCTION
EntityInformation_2 FUNCTION
EventDescription FUNCTION
EventDescriptionSuperior FUNCTION
EventSeriesChildNodes FUNCTION
EventSeriesHierarchy FUNCTION
EventSeriesSuperiorList FUNCTION
EventSeriesTopID FUNCTION
EventSpecimenNumber FUNCTION
EventSuperiorList FUNCTION
FirstLines_4 FUNCTION
FirstLinesEvent_2 FUNCTION
FirstLinesPart_2 FUNCTION
FirstLinesSeries FUNCTION
FirstLinesUnit_4 FUNCTION
LocalisationSystem_List FUNCTION
ManagerCollectionList FUNCTION
MethodChildNodes FUNCTION
MethodHierarchy FUNCTION
MethodHierarchyAll FUNCTION
NameList FUNCTION
NameListMyxomycetes FUNCTION
NameListPlants FUNCTION
NextFreeAccNr FUNCTION
NextFreeAccNumber FUNCTION
PrivacyConsentInfo FUNCTION
ProcessingChildNodes FUNCTION
ProcessingHierarchy FUNCTION
ProcessingHierarchyAll FUNCTION
ProcessingListForPart FUNCTION
ProcessingProjectList FUNCTION
ProjectDataLastChanges FUNCTION
RequesterCollectionList FUNCTION
StableIdentifier FUNCTION
TaskChildNodes FUNCTION
TaskCollectionHierarchySeparator FUNCTION
TaskHierarchy FUNCTION
TaskHierarchyAll FUNCTION
TaskHierarchySeparator FUNCTION
TaxonWithQualifier FUNCTION
TransactionChildNodes FUNCTION
TransactionChildNodesAccess FUNCTION
TransactionCurrency FUNCTION
TransactionHierarchy FUNCTION
TransactionHierarchyAccess FUNCTION
TransactionHierarchyAll FUNCTION
UserCollectionList FUNCTION
UserID FUNCTION
Version FUNCTION
VersionClient FUNCTION
DeleteXmlAttribute PROCEDURE
DeleteXmlNode PROCEDURE
procCopyCollectionSpecimen2 PROCEDURE
procCopyCollectionSpecimenPart PROCEDURE
procFillCacheDescription PROCEDURE
procInsertCollectionEventCopy PROCEDURE
procSetVersionCollectionEvent PROCEDURE
procSetVersionCollectionSpecimen PROCEDURE
SetXmlAttribute PROCEDURE
SetXmlValue PROCEDURE