Restrict access to specific import sets/data sources

[Morten Steenbac]

I have created 4 import sets for Asset Managers to bulk import/update assets from a spreadsheet.

To give them access to use the import sets on a daily basis, I can give them the import_set_loader and import_transformer roles.

But that gives them access to all import sets in the instance.

I'm thinking about different approaches to create ACL's to restrict access to only use the 4 asset mgmt specific import sets.

Anyone has come up some nice solutions for that?

[Michael Ritchie · Accepted solution]

Morten, you may want to look at my "Consumerize" Data Imports to Non-ServiceNow Administrators solution on this community:

"Consumerize" Data Imports to Non-ServiceNow Administrators

This would allow you to create record producers that you can then restrict to your specific users via User Criteria for them to import.

Another alternative is to use the Easy Import feature:

Easy import

This is an option from a list to right click and import records.   Out of the box this is only available to administrators but you can navigate to System UI \ UI Context Menus, search for name=import and add additional record for specific tables and specific roles.

[Morten Steenbac]

Hi michael.ritchie - that looks really promising. I'll test it out and get back.

I looked at easy import also, but it didn't support the requirements for the solution.

[Michael Ritchie]

Before you rule out easy import, one thing to note is once you go through the process once, a import set table and default transform map are created for you.   You can easily adjust the transform map beyond the defaults to meet your needs.   This unfortunately isn't documented but something I have done several times with success.

[Morten Steenbac]

Really?! That's a nice feature - I will definitely look into that.