mibuso.com

Microsoft Business Solutions online community
It is currently Sun Sep 21, 2014 4:00 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Field Level permission
PostPosted: Thu Apr 28, 2011 2:08 pm 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 2059
Location: Wilrijk, Belgium
Country: Belgium (be)
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.


Top
 Profile  
 
 Post subject: Re: Field Level permission
PostPosted: Thu Apr 28, 2011 4:59 pm 
Offline

Joined: Wed Nov 24, 1999 8:01 am
Posts: 580
Location: Aalborg,Denmark
Country: Denmark (dk)
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: