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} PASSWORDThe password can only be entered encrypted, this string is for "welcome1".
'D7EDED84BC624A917F5B462A4DCA05CDCE256EEEEEDC97D54A286E822D97C35C7AD5C43AD4F2A09EAC4D07C3A079829F'
PERIODICITY 90 HAS ROLES ( "Administrators", "XMLP_ADMIN" ) DESCRIPTION
{password = welcome1} PRIVILEGES ( READ);
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:
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
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
Post a Comment