Table of Contents

Search

  1. Preface
  2. Data Profiling
  3. Profiles
  4. Profile results
  5. Tuning data profiling task performance
  6. Troubleshooting

Data Profiling

Data Profiling

Assign permissions and privileges

Assign permissions and privileges

Permissions determine the access rights that a user has for a Secure Agent, Secure Agent group, connection, schedule, or asset. To configure permissions on an object, you need privileges that you can assign to users or groups.
You need one or more of the following permissions to access objects or assets:
  • Create
  • Read
  • Update
  • Delete
  • Run
For more information about permissions, see
Asset Management
.
A role is a collection of privileges that you can assign to users and groups. To ensure that every user can access assets and perform tasks in your organization, assign at least one role to each user or user group. A role defines the privileges for different types of assets and service features. For example, users with the Designer role can create, read, update, delete, and set permissions on
data profiling
assets. However, they have no access to certain Administrator service features, such as sub-organizations and audit logs.
Administrators can configure and assign roles for the organization. If the user has a system-defined role, you do not have to set privileges or asset permissions because the system-defined roles include necessary privileges and permissions.
Data Profiling
users can be assigned the Admin, Data Integration Data Previewer Designer, Monitor, and Operator roles.
For more information about creating user and user groups, see
Administrator
in the Administrator help.
The following table lists the
Data Profiling
features and asset permissions that system-defined roles grant to users:
Role
Create
Read
Update
Delete
Run
Set Permissions
Features
Admin
X
X
X
X
X
X
Compare Columns
Compare Data Profiling Runs
Data Profiling results - view
Drill down
Export Data Profiling Results
Manage Rules
Query - Create
Query - Submit
Operational Insights - view
Sensitive Data - view
Data Integration Data Previewer*
X
Data Integration - Data Preview
Designer
X
X
X
X
X
X
Compare Columns
Compare Data Profiling Runs
Data Profiling results - view
Drill down
Export Data Profiling Results
Manage Rules
Query - Create
Query - Submit
Sensitive Data - view
Monitor
X
Compare Columns
Compare Data Profiling Runs
Data Profiling results - view
Operator
X
Compare Columns
Compare Data Profiling Runs
Data Profiling results - view
Operational Insights - view
*In addition to the Data Integration Data Previewer role, you also need the Admin or Designer role to view the Data Preview tab.
The following table lists the privileges that are available for
Data Profiling
:
Privilege
Description
Data Profiling
Create, read, update, delete, run, and set permissions for a
data profiling
task.
Data Profiling
- Compare Columns
Compare columns in a profile run.
Data Profiling
- Compare Data Profiling Runs
Compare multiple profile runs.
Data Profiling
- Data Profiling Results - View*
  • View the profiling results for a
    data profiling
    task for any user including the user who created the
    data profiling
    task.
  • View the valid and invalid rows in the
    Data Governance and Catalog
    scorecard using the
    Preview of Successful Rows
    and
    Preview of Unsuccessful Rows
    .
Data Profiling
- Drill down*
View and select the drill-down option when you create a
data profiling
task.
Data Profiling
- Export Data Profiling Results
Export the profiling results to a Microsoft Excel file.
Data Profiling
- Manage Rules
Add or delete rules for a
data profiling
task.
Data Profiling
- Query - Create
Create a query.
Data Profiling
- Query - Submit
Run a query and view query results.
Data Integration
- Data Preview
View source object data in the
Data Preview
area.
Data Profiling
Sensitive Data - view
Hide sensitive information for a particular user role. When the
Sensitive Data - view
privilege is configured, you cannot view the minimum value, maximum value, and most frequent values information in the
compare column
tab.
Data Profiling
Disable Data Value Storage
Does not store minimum, maximum, and most frequent values in the profiling warehouse. When you configure the
Disable Data Value Storage
feature, the sensitive information is not stored in the profile results and the source system. The values are not stored even if you have permissions to view the sensitive data, or if you configure a profiling task with the
Maximum Number of Value Frequency Pairs
option. By default, this feature is disabled. When the feature is disabled, the values are stored as expected.
* To perform drill down, and to view the
Preview of Successful Rows
and
Preview of Unsuccessful Rows
in a
Data Governance and Catalog
scorecard, you need the following privileges:
  • Data Profiling
    - Query - Create
  • Data Profiling
    - Query - Submit
  • Data Profiling
    - Data Profiling Results - View
  • Data Profiling
    Sensitive Data - view
The following table describes how the
Disable Data Value Storage
and
Sensitive Data- view
features function when they are configured for different user roles:
Features
Custom role
Administrator or Designer
Result
Disable Data Value Storage
Inactive
Active
Sensitive information is not stored.
Active
Inactive
Sensitive information is not stored.
Sensitive Data- view
Inactive
Active
Sensitive information is displayed.
Active
Inactive
Sensitive information is displayed.
When you activate the
Disable Data Value Storage
feature,
Data Profiling
or the source system does not store the sensitive information.

0 COMMENTS

We’d like to hear from you!