nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Ability to Manage User Access to Data Flows

Farnaz Mostowfi

Organization Name

Motability Operations Ltd

Description

Currently, all users with DV Authors application role can access the Data Flows to create a new one. We would need an option to limit user access to Data Flow pages. One possible solution is to have a new user privilege specific to Data Flows.

Use Case and Business Need

The situation is that some users are authors and should be able to create for example data sets but we don't want the same group to create/add Data flows too.

With the restriction on the user's privileges, we guarantee a healthier server with less unnecessarily load on resources such as memory and disks.

Original Idea Number: 2f475c6f08

Find more posts tagged with

Under Review

Analysis and Data Visualization

Administration

Data Preparation and Flows

Status: Under Review

Comments

Jacques V.-Oracle

Would you envision this role to be able to run a data flow that someone else created ? or not access at all ?

Farnaz Mostowfi

In an ideal scenario, we would benefit from access levels of Full Control, Read-Write and Read-Only on Data Flow.

Thanks,

Farnaz

Bret Grinslade - Oracle Analytics-Oracle

Looks like you want to control the features end users can use. Is there a specific goal? Data flows are useful even for uploaded content like an excel spreadsheet. It would be good to understand your goal to inform our approach.

Farnaz Mostowfi

As mentioned in the main post, with the restriction on the user's access, we guarantee a healthier server with less unnecessarily load on resources such as memory and disks.

The situation is that we have connections to our Snowflake Data Lake defined in OAS DV. Business users are then given access to create data sets and projects as part of their discovery and as they are pleased (note currently server admins have no options to enforce filters or row limits).

We have noticed it is actually not very difficult to create a heavy load on the OAS server by selecting too many rows and/or running different scripts on them. This can actually cause the server to crash, out of memory errors and other resource issues causing the BI services to stop working.

On the other hand, we have business users with different levels of SQL knowledge or in the middle of learning DV features that we ideally don't want them to test for example ML algorithm within a Data Flow on a 400m rows cached data set ...

Hope this answers your question.