Filter recordset by user access with where clause

Question

Is it possible to provide a user with an already filtered recordset or table? Example - we have one large table that contains records for a number of technicians. When a technician logs in he should only see the records that are related to him. He should not have access to any other records. There is a field in this table that contains his name.

Answer 1

The functionality you describe is called Row Level Security. This is a core part of the dbFront functionality.

Please see the following topics for more details about implementing security:

• Row Level Security
• User Level Security