Field Level permission

AdministratorAdministrator Posts: 2,260Member, Moderator, Administrator
edited 2011-04-28 in Download section
Field Level permission
Just a few lines of code in the change log entry table and a table for the setup to manage permission on insert/modify/delete of fields that are under log.

http://www.mibuso.com/dlinfo.asp?FileID=1345

Discuss this download here.

Comments

  • pdjpdj Posts: 665Member
    Nice and simple solution :thumbsup:

    However, I will suggest changing two lines of code for performance reasons:

    IF lRecUserFieldPermission.FINDSET THEN
    into:
    IF NOT lRecUserFieldPermission.ISEMPTY THEN

    and
    IF NOT lRecUserFieldPermission.FINDFIRST THEN
    into:
    IF lRecUserFieldPermission.ISEMPTY THEN

    To improve the performance even further I would move the code to a new single instance codeunit, that loads the new table into a temporary table at first execution.
    If you are using SQL and NAV2009 R2 (or later 8)) I will suggest considering using the new triggers in Codenit 1 to catch all kinds of modifications - both direct and indirect.

    But great and simple solution - thank you for sharing =D>
    Regards
    Peter
Sign In or Register to comment.