How to give access to a user with a specific role to view "Data sources" (sys_data_source) and for them to load the records and transform it?

John Clyde Ap_a
Giga Expert

I wanted to have users with a specific role to view "Data sources" (sys_data_source) and for them to load the records and have the ability to transform it. 

find_real_file.png

I created a module with a URL link type which I was hoping would redirect to "Data Sources"

find_real_file.png

 

However, upon submitting it. I cannot seem to see the data source. It only shows this when I click "Load the Records"

find_real_file.pngfind_real_file.png

Is it a different argument? or Is there a specific role I have to add so that my user can view the data sources, load the records, and can also transform?

 

For reference this is the additional roles I added.

find_real_file.png

 

 

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

Why not give them access to Load Data OOB module

Users need to have import_admin role and they can import data.

For allowing users to create data sources, you need to check table level CREATE, WRITE ACL

Also you need to ensure those users have access to Transform map table, Field map table.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hello Ankur,

The current user can import data and the file can be reflected already on the data sources. However, I could not access the data sources if I impersonate as a user with the necessary roles. I wanted it so that when I click "Load The Records".

image

It will show this table which is the data sources (note that the table pic was directly accessed from system import sets > Administration > Data sources ,  I impersonated as the sys_admin for this)

find_real_file.png

 

So basically I wanted it to accessed through here

image

 

Is my link type argument wrong for this one?

image

Hi,

why not give link type as List of Records?

Link Type - List of Records and specify the table name

find_real_file.png

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader