Delete user from Item and Project

[Former Member]

Hi All,

How to delete user from item & project which is inherited from Item Template.

We have around 2000+ item/projects. Is there any standard report available.

Can we delete particular user from  table ACO_USER ? Is it feasible ?

Br,

Manzoor

[judith_gabriel · Accepted solution]

Dear Manzoor,

the authorization for the item can be deleted by using report RPM_DX_ITEM. It´s only possible to delete direct assigned authorization on the item.

You have to fill into the fields as follows:

  Maintenance selection: change

  Additional change selection: overwrite item authorizations

Excel-sheet:

item

  external_ID: Must be filled

  bucket_ID: Must be filled

  portfolio_ID: Must be filled

  item_type: Must be filled

item authorization

  activity: Must be filled

  user: Must be filled

  external_ID: Must be filled

Result:
You have to list in "item authorization" all users with activities which should have authorization on item. Users which are not listed here - will be deleted.

For the project you can use BAPI_BUS2172_SET_AUTHORIZATION with

authorization activity DELETE_AUTH. Further information can you find in the documentation of the BAPI in SE37.

Best regards,
Judith

[Former Member · Accepted solution]

Dear Judith,

Many Thanks for prompt reply.

You mean to say using report RPM_DX_ITEM only direct assigned authorization on the item can be deleted and not the inherited authorization ? correct.

item authorization

  activity: What value needs to be filled ???????

[judith_gabriel · Accepted solution]

Dear Manzoor,

inherited authorization can only be changed not deleted. This is the same in frontend.

The "Activity" field in the "Item authorization"-Sheet can be filled with:
ADMIN, WRITE, READ, NONE.

Best regards,

Judith

[Former Member · Accepted solution]

Dear Judith

One last question on this.

We  can delete particular user directly from  table ACO_USER ? Is it feasible or Advisable.

Br,

Manzoor