Migrating security files from 11.1.1.6.12 to 11.1.1.9

Question

Hi All,

We need to upgrade our OBIEE from 6.12 to 11.1.1.9.0, please let us how to migrate/upgrade the security(Application Roles, Groups..)

Environment is

1. Installed 11.1.1.9 new instance

2.upgrade and migrate the catalog & Rpd.

how to upgrade/migrate the security items??

Thanks,

Pentyala Avinash · Answer

LADP is configure in our Application, 11.1.1.6 having some Application roles as well 11.1.1.9 having different  role.

please let me how to merge both application roles??

Thanks,

SriniVEERAVALLI · Answer

Check these Oracle BIEE 11g - Migrating Security - Identity Stores - Part 1 - Rittman Mead Consulting

http://blogs.oracle.com/robreynolds/entry/security_in_obiee_11g_part_1

http://blogs.oracle.com/robreynolds/entry/security_in_obiee_11g_part_2