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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Security - Field Level
Microsoft Dynamics GP (Archived)

Security - Field Level

(0) ShareShare
ReportReport
Posted on by Community Member

Can someone tell me what tables contain the security setup and user assignments for field level security?

Also, what is the difference between an Alternate or Modified report or window? 

Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at

    Advanced Security Setup = WDC41101

    Field Level Security Master = WDC41300

    Field Level Security Relationship = WDC41500

    Alternate report or window = report or window from another dictionary built to replace a report or windows from MS Dyn GP (Dictionary 0)

    Modified Window = A window changed using customization tool - Modifier

    Modified Report = A report changed using customization tool - Report Writer

    You can have Modified Alternate windows.

    Tim

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,151 Most Valuable Professional on at

    Tim beat me to it. His answers are correct. Let know you any further questions. David (Original developer of Field Level Security)

  • Community Member Profile Picture
    Community Member on at

    Thanks David.  I do have some additional Questions:

    1) Does Field Level Security create an Alternate or Modified Window that I need to be concerned about in the Normal Setup using a SECMODALTID?

    2)Does Field Level Security show up in any of the Standard Security Tables(SY10600, SY10700, SY09400 etc.) or is a completely separate entity from bath a database and administrative level with the application?

    thanks!

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,151 Most Valuable Professional on at

    Hi David

    Field Level Security is trigger based as does not create Modified or Alternate windows. It does work on Modified and Alternate windows, but only on fields that exist in the original window.

    Alternate windows can only be created by a developer using Dexterity. Modified windows can only be created from original or alternate windows by using Modifier. They cannot be created by code.

    Field Level Security is independent and separate to normal security. It is only applied if a user is allowed to open the window by normal security.

    David

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans