User Management in OBIEE using BI Administration Tool

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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

18 comments
Paul says September 5, 2008

Atul,
This article is very useful. I could install & setup users very quickly with your articles on OBIEE articles.

Thanks a lot !

Reply
kala says November 26, 2008

Hi,

Atul,

Could you tell me how to configure the BI Publisher in OBIEE 10.1.3.4.

Many thanks.

Kala

Reply
Atul Kumar says November 26, 2008

Kala,
Check chapter 11 of guide BI Infrastructure & Installation Guide at

http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b31765.pdf

Reply
jsethi3 says January 8, 2009

Is it possible to integrate OBIEE with Oracle Web Center? Any documentation?

Reply
Ramana says February 26, 2009

Thanks Atul for the info.
In the downloads section in Oracle website I could not find clent software for OBIEE.
Do we need to install entire suite to access BI administration tool??

Could you please send me link to download obiee client software?

Many Thanks,
Ramana

Reply
Atul Kumar says February 26, 2009

Ramana,
Use same software (server one) to install client but during installation select client tool only

Reply
Veena says March 11, 2009

My administrator account has got locked. Can anyone please tell me how to unlock it..

Reply
amoyeed says March 18, 2009

Hi Atul,

I was going through the BI Publisher Tutorial on OTN. At one place the tutorial mentions to Right Click the Chart to edit it as follows:

“If you have time, perform the following steps to edit the chart in the template file to change the graph style, and publish it as Template3:
Right-click the chart in the template and select BI Publisher Chart to edit the chart:”

But when I Right-Click the Chart, I do not get the BI Publisher Chart option in the menu. I am using OBIEE 10.1.3.4.

Please, send your expert comment and suggestion as to “How to Edit the Chart in BI Publisher 10.1.3.4″. I can Insert a new Chart but can’t Edit the Existing Chart.

Thanks,
Abdul Moyeed

Reply
Dilip says March 25, 2009

Pls update with BI as i have to implement in the new upcoming project

Reply
Guru says December 4, 2009

Atul,
Is there a way to create a Admin user in RPD that has restrictions on certain connection pools and catalogs etc..

Reply
venkat says February 7, 2010

Any one have idea about how to establish SSO for obiee from peoplesoft portal , sothat obiee can access through portal with out re etering the obiee credentials.

Thanks

Reply
vikasarora says February 28, 2010

Dear Atul,

Could you please post the steps for “Integration of OBIEE with OID and Single Sign-On”

Thanks,
Vikas Arora

Reply
Seema says March 30, 2010

Hi Atul
Useful blog, especially for a beginner!
I realised that the groups such as XMLP_ADMIN etc need to be first created in the Admin tool before the admin page can be accessed on BI Publisher. This is definitely the case when we are creating a new repository. Is this a problem with the installation or a bug??

Am working on 10.1.3.4.1.

Thanks
Seema

Reply
morton says April 21, 2010

Hi,

I’ve tried to create users also on Admin Tool, but I didn’t see those “Group Membership” when creating it. I don’t have those XMLP_ADMIN, etc. I still continued creating the user without those. Are the users created here, the one’s you need to use on logging in Presentation Services (Answers,etc) ?
I’m stuck on this part, I got confuse on the different purpose of having user for Publisher, Presentation Services and then Admin Tool. Could you explain what’s the relationship of those?

Thanks.

Reply
oracle12018@gmail.com says August 2, 2010

How can i used this obiee in r12 (mean which responseablity is used for dashhborad and rpd file)

Reply
saurabh says October 14, 2010

Hi Atul,

I am new for OBIEE, basically i come from the oracle Apps background and in my project we implement the BI Dashboard.

Here i have one question like if we create one user can we have any functionality that that particulat user can reset there password itself.

Thanks,
Saurabh

Reply
Capitalist says March 9, 2011

Good day!

In BI Publisher 10.1.4…

I am trying to retrieve the “Currently logged-on” username,
& then use that username in a SQL query in a BI Publisher report.

URGENT!

Your assistance is highly appreciated.

ENVIRONMENT:

AIX –>5.3
OID –>10.1.4
BI PUBLISHER –>10.1.3.4.0
ORACLE DB –>11g

Authentication is through Oracle SSO, not OAM.

Reply
skateboarding shop says June 19, 2012

I like the helpful info you provide in your articles. I will bookmark your blog and check again here regularly.
I am quite sure I will learn many new stuff right
here! Good luck for the next!

Reply
Add Your Reply