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.
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.
‘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
userImport.udml
Step 2: Run the command to load the users
Once above file is ready locate the exe file called nqudmlexec.exe
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
C:\OracleBI\server\Bin>nqudmlexec -U -P
I userImport.udml -B Security.rpd -O Security1.rpd
Importing OBIEE Users to repository
Posts
