Friday, August 22, 2008

OBIEE scripting user into the repository

On the OTN forum today there was a question about how to script a new user into the repository: http://forums.oracle.com/forums/thread.jspa?threadID=697646&tstart=0

The only way I know is using the nQUDMLExec.exe


First create a txt file with your new users:



DECLARE USER "NewUser" AS "NewUser" UPGRADE ID 1 FULL NAME {New User} PASSWORD
'D7EDED84BC624A917F5B462A4DCA05CDCE256EEEEEDC97D54A286E822D97C35C7AD5C43AD4F2A09EAC4D07C3A079829F'
PERIODICITY 90 HAS ROLES ( "Administrators", "XMLP_ADMIN" ) DESCRIPTION
{password = welcome1} PRIVILEGES ( READ);
The password can only be entered encrypted, this string is for "welcome1".

Next you have to "merge" the txt file into the reopsitory:


E:\OracleBI\server\Bin>nQUDMLExec.exe -U Administrator -P Administrator -I E:\temp\NewUser.txt -B E:\temp\paint.rpd -O e:\temp\newrep.rpd




Check the new repository!
Till next Time

2 comments:

py said...

Hi John,

I import all my groups (roles) and users 'one time' without problem with your method but I want to do it many times.

I see that the users/groups seems to be deleted and imported again. That means that all the specifications made on these items (between the first import and the second one) will be lost.
Is'it any possibility doing an update in place of and delete-insert ????

Thanks

John Minkjan said...

What you could is make a extraction from the rpd first using nQUDMLGen.exe, do a search for the "current version" of your groups/users, add them to the new "script" and run that.

Regards

John