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 …….