on 12-16-2010 6:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dan,
Have you tried doing a full process on the application after adding all the database entries?
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.