Importing / Creating Users in OBIEE+

Post date: 14-Apr-2010 05:55:15

Requirement : Often time its really a pain to create users in bulk.So below script will be helpful to create users with default password.

Step 1: Create the script as shown below.

This script basically creates a declaration syntex for OBIEE.

Run the SQL Command like to Generate the File Called : userImport.udml (or you may use excel or something else )

SELECT

‘DECLARE USER “‘|| Sales_person ||’” AS “‘||Sales_person ||’” UPGRADE ID 1121 FULL NAME {’||Sales_Person_Name||’} PASSWORD ”’Welcome”’ PRIVILEGES ( READ);’ FROM tbl_sales_person

Modify the script according to the usage.

save the output of the above sql command to a file called

userImport.udml

Step 2: Run the command to load the users

Once above file is ready locate the exe file called nqudmlexec.exe

(History : nqudmlexec.exe – check the name, it starts with nq. Siebel had acquired nQuire Software in 2001. Still lots of logs, exes still have prefix nq)

Run the below command to

C:\OracleBI\server\Bin>nqudmlexec -U -P

I userImport.udml -B Security.rpd -O Security1.rpd