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

Previous in series Next in series

Related Posts for Business Intelligence


  1. Oracle Business Intelligence Enterprise Edition Overview
  2. BIEE Installation on Linux (Business Intelligence Enterprise Edition)
  3. Oracle BI Publisher Cluster / HA
  4. Clustering Oracle Business Intelligence , BI Server, Presentation Services, Plug-In, Scheduler & Javahost
  5. OBIEE – Step by Step Installation
  6. User Management in OBIEE using BI Administration Tool
  7. Integrate Oracle BI Server with LDAP Server (OID – Oracle Internet Directory)
  8. Oracle BI Publisher Admin Console (xmlpserver) Login Issue : Administrator/Administrator
  9. How to install OBIEE on windows 7 (OBIEE Training)
  10. OBIEE 11g (11.1.1.3.0) Download & Installation
  11. OBIEE 11g Installation : High Level Steps
  12. Unable to login to OBIEE /Analytics after OID integration : %user% was authenticated but could not be located within the identity store
  13. Configure OBIEE 11g Client to connect to 11g RPD in online mode
  14. Integrate OBIEE 11g with OAM 11g for Single Sign-On in 13 steps