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 |