Security Filter (record level security) based on USERID

Matthias_Claes · 2010-04-16

Using Dynamics NAV 5.0 sp1 on SQL 2008.

Is it possible to to specify a security filter based on USERID on table data in the Roles definition?
(e.g. Performance Journal: Field Engineer Name=USERID)

We have a table where the USERID of the user that created the record is stored, but I only want the users to see the records they created themselves.
I know about the consequences of using security filters (requiring additional indirect acces and adding SETPERMISSIONFILTER in code), but I want to prevent the users from seeing data they're not supposed to see.

matttrax · 2010-04-16

Security filters require hard coded filters. You'll have to write some code for what you want to do.

Security Filter (record level security) based on USERID

Comments

Categories