web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Unable to get data from datasource if system admin role removed..

(0) ShareShare
ReportReport
Posted on by 97

Hi All,

There is one standard table HcmWorkerBankAccount. If i have system admin role then i can get data from form data source (HcmWorkerBankAccount), If i have remove system admin role unable to get data from form Datasource. when i check in back end i got one policy related to this table. I created one role and added this table to the role and granted all access but still unable to retrieve data.

What should i do need to do to get data even sys admin role is not there. Do i need to create a separate role and map this policy. How to do this?

pastedimage1681952773935v1.png

pastedimage1681952848213v2.png

Thanks in advance.

  • Mohit Rampal Profile Picture
    12,573 Moderator on at

    Hi, Are you able to access Worker Bank accounts form from UI (with Non Sys-Admin account) and only worker attached to user's data is visible? If yes, then it would be due to XDS

    alexdmeyer.com/.../

  • PJ JohnPaul Profile Picture
    97 on at

    Hi Mohit,

    Thanks for the reply.

    Without sys admin role , delete option is visible in form

    pastedimage1681954979829v1.png

  • Mohit Rampal Profile Picture
    12,573 Moderator on at

    I tried creating a new Security role and assigned only these privileges and able to see the workers and their bank accounts.

    pastedimage1681956046679v1.png

    pastedimage1681956068493v2.png

  • PJ JohnPaul Profile Picture
    97 on at

    Hi Mohit,

    I can also create and delete bank accounts but not able to get data in code.

    pastedimage1681957076555v1.png

  • Bharani Preetham Peraka Profile Picture
    3,634 Moderator on at

    As Mohit suggested it is due to XDS. For example even if you have admin access also, you cannot see workflows waiting for some manager approval. Only the user with manager role can see them.

    But I don't understand if you can do this by admin role, why you want to remap or to recreate a new role? Are you saying even with admin, you cannot get data from code in backend?

  • PJ JohnPaul Profile Picture
    97 on at

    Hi Bharani,

    Thanks for the reply,

    I can get data in backend with sys admin role.

    But i can't assign sys admin access to all users. I need to do with separate role only.

    How to get data in backend for this HcmWorkerBankAccount table without sysadmin .

    what should i need to do. Kindly advise me.

    Thanks

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    3,634 Moderator on at

    Without system admin role, if you want to get data means you should be that user with that role where you can get data. I would suggest you to check this with FC for which roles can this data be seen. So you can assume that role or create a new role which is similar that role which FC is mentioning.

  • Suggested answer
    Mohit Rampal Profile Picture
    12,573 Moderator on at

     PJ JohnPaul Can you try disabling XDS policy in your code. (I'm not sure if its best practice but please check if it works). If it works then you have to check the User's role as well, so it won't work for all non admin roles.

    ievgensaxblog.wordpress.com/.../

  • PJ JohnPaul Profile Picture
    97 on at

    Hi mohit,

    Disabling xds is also not working.


    pastedimage1681964502668v1.png 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 366

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 360 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans