Migration of the Security Stores – OBIEE11g

http://debaatobiee.wordpress.com/2012/01/08/migration-of-the-security-stores-obiee11g/

In my recent up-gradation projects after doing the Up-gradation in Dev Environment it is a obvious question that how I get my security setup migrated to say Test environment . One easy way to do this is just up-grade your Test env and during the up-grade process your user/group list will be automatically updated to the security store of 11g and will be automatically done by Upgrade assistant behind the scene. However this is a work around but this process is not the Oracle suggested method for security policy store migration.

The actual process to do this is using the Migration assistant under Security realm of  Weblogic Console. See below image . Go to Export tab and put any directory name where you want the exported copy like : D:\Share\Security …

The .dat file list would be like below:

Now once you get this list click on Import button of the target environment (say. Test) and simply click the update button . You will see all list of users and groups will be automatically migrated from Dev to Test .