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

Mass assignment of different roles to different users

Hello all,

my requirements are the following:

We are migrating to BI 7.0 AND establish a new role concept. So I have created lots of new roles and each of them has to substitute an old, obsolete one actually assinged only as single roles to the users. The user assignments have to be changed and I will have to assign about 50 composite roles and 200 single roles to the existing 2500 users and to remove the old ones.

SU10 is not sufficient for me because I have to either group users and assign & remove the roles (grouping of users is not done yet and everyone is unique/different) or to group by roles and assign and remove the roles. This is a lot of efford and in case of error recovery I cannot react as fast as necessary.

Is there an option to perform this? I am thinking about a report reading my already existing master file (*.csv) and assigning the defined roles to the users and to remove the defined old one from the users.

Does anyone have alternate suggestions?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2007 at 07:00 PM

    Hello Perta,

    I would say in such a scenario this is the best approach. As a matter of fact we use a similar program in our normal production environment. We use a file to upload roles for the users. The file deletes existing role assignments and then inserts the ones present in the file.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Ben, hello Ruchit,

      thanks for your inputs.

      I think the best solution is to create a program for the whole sczenario as I am VERY familiar with all the possibilities in SU10 and its restrictions (regarding removing roles and profiles). As you told we will need a recovery procedure for our users and roles and I am not talking about some small end strict defined user groups with some roles assigned but of at least 30.000 entries in table agr_users.



  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2007 at 07:06 PM


    Your options are custom programming as stated above or ECATT/CATT scripts.

    Search eCATT for details. For CATT there is a work around on newer versions using transaction SCEM.



    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.