Skip to main content

Notifications

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.

  • PJ JohnPaul Profile Picture
    PJ JohnPaul 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 

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 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/.../

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 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.

  • PJ JohnPaul Profile Picture
    PJ JohnPaul 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

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 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
    PJ JohnPaul 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

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 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
    PJ JohnPaul 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
    Mohit Rampal 12,554 Super User 2024 Season 1 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/.../

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans