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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2022 07:31 AM
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.
I created a module with a URL link type which I was hoping would redirect to "Data Sources"
However, upon submitting it. I cannot seem to see the data source. It only shows this when I click "Load the Records"
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.
- Labels:
-
Service Portal Development
-
Studio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2022 07:44 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2022 08:02 AM
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".
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)
So basically I wanted it to accessed through here
Is my link type argument wrong for this one?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2022 10:44 PM