Menu

Filter recordset by user access with where clause

0 votes

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.

in Security by (340 points)
recategorized by

1 Answer

0 votes
 
Best answer

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:

by (44.5k points)
selected by
Row Level Security examples including CASE and IF
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...