Oracle Business Intelligence 11g - Authentication Creating Users

Now it comes to user authentication in Oracle Business Intelligence 11g. As you already see the installation steps, OBI is installed with the integration of WebLogic Server. Although there’s a repository file which is created by default as sample, you need to create user account in the WebLogic Server. You’ll have a chance for accessing the list of users in the repository file (*.rpd). You still edit the repository by using the BI Administration tool. But creating the user is done through the WebLogic Server Console. First I login to WebLogic console.

I open the BI Administration Tool open the repository in “Online” mode. When you click the manage menu on the tool bar, you’ll see the “Identity” management which about security, user accounts permissions etc. It’s the same as Security Manager in the 10g version with some exceptions. I can see the list of users groups but don’t have any option to create the user object.

So that’s why I goto Security Realm in the WebLogic Console. In the “Users Groups” tab, you’ll see the users groups tabs. I click the new button start to create the user.

First I specify the username password. set the authentication provider. 

Next step is related with the group membership. I make the new user as a member of BI Administrators group. , save the changes. 

After creating the new user, I can see the user in the identity manager (security manager). In addition to that list, I can successfully login to the BI server with the new user.

Oracle Business Intelligence 11g - Installation Steps I

After I extract the downloaded installation files, I’m going to create the repository for the Business Intelligence tool. In order to create the repository, there is a tool named “Repository Creation Utility” so I’m going to run this executable: rcu.bat

When I run rcu.bat file, it warns me about the resolution. So I just skip that warning.

The next window is the welcome window. So I easily skip this step, too.

, it asks for the creating repository or the dropping repository option. It’s new installation notrepository exists in the database. I select create option to create the repository.

In the database connection window, I specify the connection string, database username password.

The installer checks the character set of the database shows a warning dialog box. I ignore that warning. Normally UTF8 is recommended.

The installer checks the prerequisites of the repository creation. It is highly recommended that all the steps should pass the minimum configuration.

, in the “Select Components” window, I select the Oracle Business Intelligence as a component. It automatically selects other dependent components, too. the installer sets the schema owners of the components that will be installed.

, another prerequisite check comes. I simply click “OK” button.

, I set the tablespaces for the repository tables. One for Metadata Services one for Business Intelligence Platform.

, it warns you that the specified tablespaces don’t exist in the database it’s going to create them. So I just click “OK” to continue.

It creates tablespaces.

In the Summary page, I confirm the components, schema owners tablespaces.

, it creates the repository.