You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?

edited Nov 13, 2020 11:07PM in Reporting and Analytics for ERP 4 comments

Summary

Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query so they cannot query HR tables.

Content

Assigning the BI Admin role to a user in ERP Cloud will grant access to create a Data Model. From there, they can create a data model based on a SQL Query, XML, CSV, etc. This access will also allow them to create a data model from Oracle BI Analysis. 

We would like to grant our users the access to create data models from BI Analysis, but we need to restrict the SQL Query option so they can't query on HR tables.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!