Skip to Content

Access to multiple packages

Hi All,

IDM 8

I have 10 users to be given access to Eclipse to nearly 20 odd packages. So, instead of selecting a package and adding a user, i believe i can update a table for the same.

I am trying on this. you may choose to answer meanwhile.

Note: The sap help library only mentions adding 1 package at a time https://help.sap.com/viewer/4773a9ae1296411a9d5c24873a8d418c/8.0/en-US/a823342a2d8f4f429cc3e0b28ddf64d2.html

Regards

Plaban

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jul 05, 2019 at 08:18 AM

    Hi Steffi,

    MSSQL is

    DECLARE packageIDs CURSOR FOR
    select mcPackageId from mc_package
    GO
    BEGIN
    DECLARE    @packageIDs_var int
    DECLARE    ‎@myUserId int
    SELECT @myUserId = (select mcUserID from mc_users where mcUserName = '<enter username here (without <>) >')
    OPEN packageIDs
    FETCH NEXT FROM packageIDs INTO @packageIDs_var
    WHILE @@FETCH_STATUS = 0
    BEGIN
    insert into mc_user_auth values (@myUserId, ‎@packageIDs_var, 1)
    FETCH packageIDs INTO @packageIDs_var
      END
    END
    CLOSE packageIDs
    DEALLOCATE packageIDs

    While 1 in the insert statement means owner, you might want to change that value.

    Regards

    Norman

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 02, 2019 at 11:10 AM

    Hi Plaban,

    you can assign all packages to a user when opening properties of that user in Eclipse. Double click on the root node of the configuration -> switch to tab users -> double click the user -> assign the packages.

    Furthermore you can also do update table, but statement is different for every DB. What DB do you have?

    Regards

    Norman

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Norman,

      I'm on SP 6 and there is no way to add packages this way to a user. You can only edit the permission on that package for the user, if it's already assigned to him/her.

      .

      I'm also not able to delete users at all, just deactive them. Bug or feature?

      .

      Regards,

      Steffi.

  • Posted on Jul 02, 2019 at 01:56 PM

    Hi Steffi,

    well I cannot check it on the system right now, but I am sure it was there 6 month ago. What DB are you using, I can provide the queries for DB-update (but I have to mention this is not the official supported way).

    Regarding deletion I have never tried, I would open an incident for that.

    Thanks

    Norman

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Norman,

      maybe the mass assignment of packages to a user was possible with SP5? Or it's another bug in SP6, who knows.

      I'm on MSSQL, but no need for the DB update statements for me (permissions are all set and don't change so much here ^^), but I guess Plaban can really use them for his task.

      .

      It's just one user I want to delete, right now it's deactivated, so not an issue. Maybe it comes with a patch some day. :D

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.