This post covers managing users in Oracle Business Intelligence Server (OBIEE) using Security Manager in BI Administration Tool
Security Manager – is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access.
User Accounts can be defined explicitly in Oracle BI repository or External Source (Database Table or LDAP Server)
– To open Security Manager in BI Administration Tool
i) Click Administrator from Start Menu in windows or
ii) AdminTool.exe from $ORACLE_BI_HOME\server\Bin
iii) Once you are in BI Administration Tool, open repository in offline/online mode as shown in screenshot
in above example I am opening repository $ORACLE_BI_HOME\server\Repository\samplesales.rpd
Default BI repository location is $ORACLE_BI_HOME\server\Repository and these are stored in proprietary RPD format.
iv) Login to repository with Administrator account (or user with Admin privileges). Default password for Administrator account in BI is Administrator
v) once you open repository (offline/online) using BI administration tool, you will see screen like below
vi) Now open Security Manager using Manage -> Security from BI Administration toolbar
vii) To create new user click on Action -> New -> User
viii) Fill in necessary details and click in OK
Things you must know with User Management in OBIEE
i) User Accounts can be defined explicitly in
a) Oracle BI repository or
b) External Database Table or
c) LDAP Server (OID, iPlanet, Open LDAP, Novell eDirectory)
ii)Users defined explicitly in a repository can access business model in that repository only. They cannot login or access business model in other repository (user test1 above in samplesales respository can access only samplesales and not paint or any other repository stored in BI Server)
iii) Oracle BI Administrator account (Administrator) is default user when you create a Repository and cannot be deleted.
Integration of OBIEE with OID and Single Sign-On coming soon …….
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.