Skip to main content
Solved

Migration - User Grants

  • February 15, 2024
  • 6 replies
  • 109 views

rfedorchuk
Sidekick (Customer)
Forum|alt.badge.img+7

Hello All,

I have created a migration job to export User Grants, but I can’t get the File Mappings to populate.

Any thoughts?

 

Thanks,

Rob

 

Best answer by Makede

You can find some helpful information within online help about this:
https://docs.ifs.com/techdocs/22r2/030_administration/010_security/020_permission_sets/022_permission_set_import_export/#exporting_permission_sets

6 replies

Forum|alt.badge.img+11
  • Hero (Employee)
  • 106 replies
  • February 15, 2024

Hi @rfedorchuk 

USER_HANDLING_ROLE_GRANT_TYPE is a joined view based on fnd_user_role_runtime and fnd_role

But you can enter the fields manually within your file mapping:
 


BR
Martina​​​​​​​


rfedorchuk
Sidekick (Customer)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • 52 replies
  • February 15, 2024

Thanks for getting back to me.

Is this the best way to migrate the roles?


Forum|alt.badge.img+11
  • Hero (Employee)
  • 106 replies
  • February 15, 2024

If you would like to export and import permission sets and user grants maybe its better to use the following options instead of a migration job:

 

 


rfedorchuk
Sidekick (Customer)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • 52 replies
  • February 15, 2024

I was looking for something like this… thanks!

When I export the permission set (SPC_Dispatcher), it creates a zip file:

Does it matter the order that I import them back or do I just import the SPC_Dispatcher file and the system is smart enough to deal with the rest?


Forum|alt.badge.img+11
  • Hero (Employee)
  • 106 replies
  • Answer
  • February 15, 2024

rfedorchuk
Sidekick (Customer)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • 52 replies
  • February 15, 2024

Perfect.  Thanks for the document.  VERY helpful!!!!