cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BPC Security Migration To A New Server

Former Member
0 Kudos

I'm going through a server migration in SAP BPC. We currently have 150+ users, each with individual User and Member Access Profiles. I'll need to add these individuals with the same security settings on the new server which can take quite a while doing each individually in the administrative console.

I've found the following tables on the database server that contain security data:

dbo.MemberAccess

dbo.profiles

dbo.tblappaccess

dbo.tblusers

dbo.teams

dbo.userprofile

dbo.userteamassign

dbo.userteamprofileassign

I'm able to add data to these tables on the database server and have it reflected when I go into the admin console and view the security for a particular user. However, the user security access is not changed until I hit the finish button in the administrative console security dialog.

Is there a way to add all of the security data on the database server and have it process without having to go into each individual profile within the admin console and pressing the "finish" button?

Thanks,

-Dan

Accepted Solutions (0)

Answers (3)

Answers (3)

PatrickFavre
Advisor
Advisor
0 Kudos

Hi,

There is a new How-to-Guide under the following link: http://wiki.sdn.sap.com/wiki/display/BPX/EnterprisePerformanceManagement%28EPM%29How-to+Guides

It's called "How To ... Mass Import Security for BPC MS", which include a new dll called "OSoftTaskUserSecurity.dll". I think it could help you to proceed the way you would like. But be aware that it should be used with caution, and if possible not in production system.

Hope this will help.

Kind Regards,

Patrick

Former Member
0 Kudos

Hi,

It is not advisable to make the entries in the database tables directly. Other than making these entries, there are other dependencies as well. Unless and until, we dont process the security from the admin console, it will not work properly.

Hope this helps.

Former Member
0 Kudos

Hi Dan,

Have you tried doing a full process on the application after adding all the database entries?

Santosh