web
You’re offline. This is a read only version of the page.
close
Skip to main content
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.

I have the same question (0)
  • Mohit Rampal Profile Picture
    12,563 Moderator on at
    RE: Unable to get data from datasource if system admin role removed..

    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
    RE: Unable to get data from datasource if system admin role removed..

    Hi Mohit,

    Thanks for the reply.

    Without sys admin role , delete option is visible in form

    pastedimage1681954979829v1.png

  • Mohit Rampal Profile Picture
    12,563 Moderator on at
    RE: Unable to get data from datasource if system admin role removed..

    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
    RE: Unable to get data from datasource if system admin role removed..

    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
    RE: Unable to get data from datasource if system admin role removed..

    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
    RE: Unable to get data from datasource if system admin role removed..

    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
    RE: Unable to get data from datasource if system admin role removed..

    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,563 Moderator on at
    RE: Unable to get data from datasource if system admin role removed..

     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
    RE: Unable to get data from datasource if system admin role removed..

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 703 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 582 Most Valuable Professional

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 542

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans