Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Want to restrict OBIEE 12c logins to one specific AD group

wjclarkJun 20 2018 — edited Jul 3 2018

We have an OBIEE 12c installation that we would like to lock down so that only members of one certain AD group can access the application URLs.

Right now our authentication provider that was set up is wide open and allows anyone in our company with an AD account to log in. We are controlling

what people can see via a Data Security table and the OBIEE roles, but we would like to be able to keep access restricted to few.

We are trying to do this in preparation to adding an OBIEE shortcut on our SSO page and we want only those approved users to access it.

I am wondering where on the provider specific tab in settings for my Provider, do I specify the AD user group.

pastedImage_0.png

Thanks

Bill

Comments

Oyvind Isene

The first statement for declaring the package is not really relevant, or am I missing something? Anyway, I did this in latest version of SQL Developer against an 11.2.0.4 database without getting any errors:

create or replace type user1_type
AS OBJECT ( DEMO VARCHAR2(3)) ;
/

create table nobeer
( col1 user1_type ) ;

SELECT * FROM NOBEER ;

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details