Pentaho Data Quality
Data CatalogData IntegrationBusiness Analytics
  • Overview
    • Data Quality
  • Data Quality
    • Overview
      • Data Quality
    • Getting Started
      • Connectors
      • Observe
      • Measure
      • Discover
      • Remediate
    • PDQ Settings
      • General
      • Connection
      • Semantics
      • Quality
      • Integration
      • Security
      • Theme
Powered by GitBook
On this page

Was this helpful?

  1. Data Quality
  2. PDQ Settings

Security

Configure Roles & User permissions ..

PreviousIntegrationNextTheme

Last updated 7 months ago

Was this helpful?

Data security is crucial for protecting sensitive and confidential information, and for maintaining the integrity and availability of data. PDQ security helps protect sensitive and confidential information from unauthorized access, use, disclosure, disruption, modification, or destruction.

Data security can be achieved through a combination of physical, technical, and administrative controls. By selecting the Security under the settings tab, the user can view all the users across the organization and their permissions levels within the platform.

There are 3 feature options:

Manage users across the organization and their permission levels for the portal. It provides the details of Total users, Active Users, and Inactive Users.

You can also invite Users from this section by providing the Email and Role details. The different default roles in PDQ are as follows:

● Admin: Admins are responsible for the overall administration of the platform

● User - Users can read all discovered properties and metrics

● Steward - Stewards are responsible for managing asset connections and discovered properties

● QA User - Custom definition for your control and use

  1. Invite a User and select a Role.

An admin user also possesses the following controls within the Security page:

  1. Add/Modify the First Name of the user

  2. Add/Modify the Last Name of the user

  3. Add/Modify the Title of the user

  4. Assign specific Domains to the user

  5. Assign specific Applications to the user

  6. Change the Roles of a user

  7. Enable/Disable the access to a user using the Active section

  8. Delete a User

  9. Trigger a password reset link via email

  10. Reset password for other users from the settings page

Under the Roles tab, an admin user can create new custom roles and modify their privileges as per their need.

Under the features section, there are 3 different access options for various features within the platform:

● N - None

● V - View only

● E - Edit

As the name indicates, this section collects logs of the user activity and displays them for tracing back one's activities.

Information such as:

User name

Last login details

No. of audit logs

Duration statistics

Session start time

Session end time

IP address

Audit information

  1. Click on the Activity tab.

● The admin/privileged user can also push the user sessions and user activity tables to the metadata repository

● The admin/privileged user will be able to view the following options on the user activity page under the settings > General> Reporting:

○ Run now

○ Schedule

● The admin/privileged user will be able to delete/update the existing schedule and should be able to see the next run date time

● The admin/privileged will be able to view the following metadata properties in the target table based on the setup in the Reporting settings

User Activity

Metadata
Description

ATTRIBUTE_ID

The unique identifier of the attribute in PDQ. Used to join USER_METADATA.

ATTRIBUTE

The name of the attribute/column against which the user acts PDQ

AUDITTYPE

The type of action that the user performs against the asset, can be the update of metadata properties, adding a dataset, deleting a dataset, etc. There are currently 19 unique options being catalogued.

NOTIFICATION_TEXT

The alert/notification text that is generated in the PDQ platform for the user's actions.

CREATED_DATE

he timestamp at which the user performed the respective action. I believe this is UTC.

USERNAME

The name of the user in the PDQ platform

USER ROLE

The role of the user assigned in PDQ

ASSETS

Name of the data source/dataset/attribute in which the action has been performed by the user in PDQ.

CONNECTION_ID

The unique identifier of the data source. Use to join to USER_METADATA DATASOURCE_ID.

USER_ID

The unique identifier of the user in PDQ. unique to PDQ - does not correspond to Employee ID.

UserSessons

Metadata
Description

MAX_SESSION_TIME

The highest duration a user has been logged into the platform.

MIN_SESSION_TIME

The lowest duration a user has been logged into the platform.

TOTAL_LOGIN_COUNT

The number of times a user has logged into the PDQ platform.

USER_ID

Auto Generate ID assigned to a user in PDQ.

USERNAME

Name of the user provided in PDQ.

USER ROLE

The role of the user is assigned in PDQ, and every role is assigned a set of permissions.

AUDITS_COUNT

Number of actions a user performed in PDQ.

AVG_SESSION_TIME

The average time spent on PDQ by a user.

LAST_LOGGED_IN

The recent login time of the user in PDQ

x

x

x

Invite a User
Roles - Admin
User Activity