Skip to Content

Users,security and authorization on BW on HANA

Hello Gurus,

There is some good document. Which talks about the unification of Security model for the new users.


http://scn.sap.com/community/bw-hana/blog/2014/09/12/bw-on-hana-security-unification#comment-597507

I believe when we upgrade to BW on HANA, the Users/security/and authorization and all the users and security related

Stuff are not copied to HANA Database. Now we would like to moves all users/security users to HANA so that we can use the HANA security

And access via different reporting tools, not through BW app server. Is there any programs /T-code/Wizard tool that I can use to move all users/security/authorization to the SAP HANA DB without re working all these manually?

Can some one please through some light on how this can be achieved? Thank you for the help.

Regards

Ram

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 12, 2015 at 09:10 AM

    Hi Ramakrishnan,

    You can use reports/programs RSUSR_DBMS_USERS to create DBMS mapping of multiple users at a go. This works for users already existing in BW. Even if a user is already existing in HANA, it will map him to corresponding BW user.

    Limitation with above program is: if a user has been mapped to HANA user, but later HANA user is deleted, you will not know it via this program. So you can use program RSUSR_DBMS_USERS_CHECK to find such inconsistent users (as Suresh mentioned in his document) and create them via this program.

    You can use BW tcode RS2HANA_CHECK to transfer BW analysis authorizations to HANA authorizations. You can find more details on tcode on SCN.

    Regards,

    Nitesh

    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.