Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Column level access to allow users to update only certain columns on a custom entity

Posted on by 110

I've got a need to permit a group of users access only to certain columns on a custom entity.

Is there a way to do this using column security? 

Would users who have read/write access to the entity via a security role retain that access, or would I have to explicitly assign them a custom profile to preserve their access to the columns with column-level access?

Thanks,

Jessica Weissman

  • PP-29040829-0 Profile Picture
    PP-29040829-0 52 on at
    Column level access to allow users to update only certain columns on a custom entity
    Hi a3ik,
     
    If I mark primaryVendorID as 'Secured,' does it mean I can set up a special group to update this field, or not?
     
  • Verified answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Column level access to allow users to update only certain columns on a custom entity

    Alternatively, you can depending on the user role enable/disable fields using JavaScript. It's not bulletproof because there is LevelUp or other tools that might be used to disable fields easily but it's not as heavy as field-level security.

  • Jessica Weissman Profile Picture
    Jessica Weissman 110 on at
    RE: Column level access to allow users to update only certain columns on a custom entity

    Hi, Andrew, and thanks.  What I am looking for is a way to allow certain users write access only to a small subset of the columns on a custom entity.  They can view any other column.

    Everybody else with access to the entity should have read/write access to all the columns.

    It sounds like what I have to do is make all columns EXCEPT the small subset Secured.  Then create two Security profiles, one for most users that has create/read/write access to the many Secured columns and one that has read access to the many Secured columns.  

    For both profiles, they would have access to the unsecured columns by virtue of the relevant Security role.

    Not robust, but it will make the client happy.  

    Or maybe I can talk the client into skipping the whole thing and just telling the small group of users not to touch the other columns.  They're busy and shouldn't have the time to mess with anything that isn't their primary responsibility anyway.  Plus we have an audit trail.

  • Verified answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Column level access to allow users to update only certain columns on a custom entity

    Hello Jessica,

    If you would make fields "Secured" you will have to provide the mentioned group of users the profile to have the access to "Secured" fields.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans