Solved

Migration - User Grants

  • 15 February 2024
  • 6 replies
  • 37 views

Userlevel 2
Badge +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

 

icon

Best answer by Makede 15 February 2024, 19:10

View original

6 replies

Userlevel 4
Badge +10

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​​​​​​​

Userlevel 2
Badge +7

Thanks for getting back to me.

Is this the best way to migrate the roles?

Userlevel 4
Badge +10

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:

 

 

Userlevel 2
Badge +7

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?

Userlevel 4
Badge +10

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

Userlevel 2
Badge +7

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

Reply