Security Filter (record level security) based on USERID

Matthias_Claes

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

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