Using UDML Automating import Users/Groups from another db table or text file into ORACLE BI Repository .
Step 1.
SELECT
‘DECLARE USER “‘||username||’” AS “‘||username||’” UPGRADE ID 1121 FULL NAME {} PASSWORD ”welcome1” NEVER EXPIRES
PRIVILEGES ( READ);’
from rep_users
Note: Result set must be spool on your desire location like(c:\test\test.udml)
Followings scripts are : save on (c:\test\test.udml) this file
DECLARE USER "dul01" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul02" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul04" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul05" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul06" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul07" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul08" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul09" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul10" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul11" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul12" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul13" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
DECLARE USER "dul14" AS "dul01" FULL NAME {} PASSWORD "test" NEVER EXPIRES;
Step 2.
Go to your server environment ; Set environmental variable
C:\OracleBI\server\Bin>
C:\OracleBI\server\Bin> nqudmlexec -U Administrator -P Administrator -I "C:\test \test.udml" -B "C:\OracleBI\server\Repository\ BeforeUserImport.rpd" -O C:\OracleBI\server\Repository\ BeforeUserImport.rpd"
Then you login your BI Administrative Tools >Manage>Security
Now you should get a repository with all the users automatically imported into the repository
Another simple feature but can be very useful in a lot of situations.
