Object level security controls the visibility to business logical objects based on a users role. If youre evaluating obiee 11g and working through the long list of new. Whilst basic concepts such as objectlevel and datalevel security are the. Data level security in obiee 11g bi solutions by shankha. Row level security is where groups of users have access to a set of reports, but they all see different sets of data within the reports due to filters being applied silently in the background. Business intelligence bi solutions and services, big data, training, barcelona, dubai, abu dhabi. Obiee 11g advanced row level security clearpeaks blog. Oracle bi ee 11g security auditing pdf free download.
Reports created by a particular group of users should be visible to that particular group only or some specific data should be visible to only a specific set of people. Object permissions and query limits are set up in the repository and are enforced only by the oracle bi server. The image shows how data filter rules are enforced in the oracle bi server. Bmm layer, complex join, content setting in obiee, data level security, data level security in obiee 11g, filter, generating sql, manage identity, manage security, obiee 11g, order by in obiee, physical layer, presentation layer, report filter, saved filter, where clause. The difference between rpd and catalog security is that repository level. So well start this weeks focus on obiee 11g security with the topic that most people associate with security around reports row level security. Security in obiee data level security controls the visibility of data content rendered in subject areas, dashboards, oracle bi answers, and so on based on the users association to data in the transactional system. Catalogs, access control lists and permission reports. Data level security in obiee11g implementing data level security in obiee 11g with example row level security in obiee11g data level security is nothing but groups of users have access to set of reports, but the visibility of the data will be different within the reports due to filters which are applied in the backend of the report. From the documentation of bi publisher, i see that you have to enable the option use proxy authentication to pass the user information down to bi publisher from obiee when using bi server as the data source to implement row level security. Obiee is a reporting tool wherein multiple users belonging to multiple groups create multiple reports and dashboards. Datarow level security in this blog i will explain how row level security can be implemented in obiee 11g. Oracle cloud data centers offer embassygrade physical and logical security.
Obiee by shiva molabanti an obiee, odi, endeca, no sql and. After checking that option, the bi pub report does not render anymore. This controls the type and amount of data that you can see in a report. You can set up object level security for metadata repository objects, such as subject areas and presentation folders, and for web objects, such as dashboards and dashboard pages, which are defined in the presentation catalog. Data level security controls the visibility of data content rendered in subject areas, dashboards, oracle bi answers, and so on based on the users association to data in the transactional system. Applying data access security to repository objects. Obiee 11g uses weblogic for centralized common services.
1248 1471 791 1237 1101 1554 495 1523 858 1101 717 600 758 1076 1280 989 940 675 570 1594 850 24 390 58 1249 1373 722 753 860 531 904 1190 913 1130 956 843 674 1039