Rights

A right allows access to a resource, a specific part of a resource, to data or services. datasqill Server knows various rights.

Administrator Rights

First, there are the administrator rights. They are granted for the configuration database ("Configuration Repository"), which exists only once in a datasqill installation.

  • ADMIN_TRANSFORMATION_DB_CREATE: Add a new transformation database
  • ADMIN_TRANSFORMATION_DB_UPDATE: Edit transformation databases
  • ADMIN_TRANSFORMATION_DB_DELETE: Delete transformation databases
  • ADMIN_AUTHORIZATION_CREATE: Create new users and roles
  • ADMIN_AUTHORIZATION_READ: Display existing users and roles
  • ADMIN_AUTHORIZATION_UPDATE: Modify roles and user permissions
  • ADMIN_AUTHORIZATION_DELETE: Delete roles

After installation of the datasqill Server, no permissions are stored. The first user who connects to the environment is automatically granted administrator rights so they can continue the setup.

rights

Rights for Transformation Environments

There are also various rights for each transformation environment:

  • EDITOR_TRANSFORMATION_DB_READ: Connect to a transformation database
  • EDITOR_TRANSFORMATIONS_FOLDER_CREATE: Create a new transformation folder
  • EDITOR_TRANSFORMATIONS_FOLDER_UPDATE: Rename a transformation folder
  • EDITOR_TRANSFORMATIONS_FOLDER_DELETE: Delete a transformation folder
  • EDITOR_TRANSFORMATIONS_FOLDER_EXECUTE: Execute a transformation folder
  • EDITOR_TRANSFORMATIONS_SHEET_CREATE: Create a new transformation sheet
  • EDITOR_TRANSFORMATIONS_SHEET_READ: Open a transformation sheet
  • EDITOR_TRANSFORMATIONS_SHEET_UPDATE: Rename a transformation sheet
  • EDITOR_TRANSFORMATIONS_SHEET_DELETE: Delete a transformation sheet
  • EDITOR_TRANSFORMATIONS_SHEET_EXECUTE: Execute a transformation sheet
  • EDITOR_TRANSFORMATIONS_SHEET_CONTENT_EDIT: Edit a transformation sheet
  • EDITOR_BATCHES_FOLDER_CREATE: Create a new batch folder
  • EDITOR_BATCHES_FOLDER_UPDATE: Rename a batch folder
  • EDITOR_BATCHES_FOLDER_DELETE: Delete a batch folder
  • EDITOR_BATCHES_BATCH_CREATE: Create a new batch
  • EDITOR_BATCHES_BATCH_READ: Open a batch
  • EDITOR_BATCHES_BATCH_UPDATE: Edit a batch
  • EDITOR_BATCHES_BATCH_DELETE: Delete a batch
  • EDITOR_BATCHES_BATCH_EXECUTE: Execute a batch
  • EDITOR_RUNS_RUN_READ: Open a run
  • EDITOR_RUNS_RUN_EXECUTE: Execute actions for a run
  • EDITOR_SETTINGS_CONNECTIONS_CREATE: Create new connections and schemas
  • EDITOR_SETTINGS_CONNECTIONS_READ: Display existing connections and schemas
  • EDITOR_SETTINGS_CONNECTIONS_UPDATE: Edit connections and schemas
  • EDITOR_SETTINGS_CONNECTIONS_DELETE: Delete connections and schemas

The datasqill Administrator can grant users fine-grained different rights for reading, creating, modifying, deleting, or executing objects for the various transformation environments.

This assignment of rights is described in the section Permissions.