Set security in data Model

Mohamed Mohsen

Some users have access to the Data Model, and the customer needs to set security restrictions within the Data Model. For example, User X should only be able to see employees in Payroll 1 and should not have access to any data for employees in Payroll 2.

However, when User X creates any SQL query in the Data Model, the results include data from both Payroll 1 and Payroll 2.

I’ve reviewed the roles related to User X, and they all inherit security profiles, except for the BI Consumer and BI Author roles, which do not seem to enforce these security restrictions.

Has anyone encountered this issue before, and if so, what solutions did you find effective?

Simon Ng

check out usage of Business Intelligence Publisher Secured List Views

MandeepGupta

Hi @Mohamed Mohsen,

This is not possible. Once the user have access to BIP data model and select from a table, they can access data from all tables.

@user10597052,

Secured views work well for end user who just has access to run a report. But for a person with create data model access, this is not possible to restrict data in a table based on security profile.

Thanks.

Bhaskar Konar

Hi @Mohamed Mohsen,

You've to control the access to Data Model developer role. It should not be allowed to the end users if they have data view restrictions.

It is primarily a get-way to the Database so if someone can get the access the can access all the tables that present in the database like secured or non-secured.

Hope this help.

Cheers,