Skip to Content
author's profile photo Former Member
Former Member

SAP BPC Security Migration To A New Server

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 17, 2010 at 12:39 AM

    Hi Dan,

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

    Santosh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2010 at 03:16 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2010 at 09:08 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.