Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Restrict data model creation to only access views

61
Views
5
Comments

Organization Name

Office Depot

Description

Currently if user has access to "BI Publisher Data Model Developer" then he can query any table and views from database. We need ability to restrict user to query only "views" from database which only gives access to data based on users data access. This will restrict data modeler to access any data than user is allowed.

Use Case and Business Need

Restrict data access for user who has "BI Publisher Data Model Developer"

Original Idea Number: f0656f7c6c

3
3 votes

Submitted · Last Updated

Comments

  • Kathy King
    Kathy King Rank 2 - Community Beginner

    This might be of great assistance to us as well.  Currently, our company limits that type of access to IT for security reasons and they are not very familiar with the detailed applications flows in purchasing, Accounting, etc.

  • Farooq H Syed
    Farooq H Syed Rank 4 - Community Specialist

    This will be increase the security.

  • Dipti
    Dipti Rank 1 - Community Starter

    This is exactly what we need as well.

  • Milind Dalvi
    Milind Dalvi Rank 3 - Community Apprentice

    NA

  • Aditya Jena
    Aditya Jena Rank 1 - Community Starter

    Yes this is very much required to achieve security related regulations.