Hi , Does anyone know of a recommended way of display data specific to one user login. Simple example there's a FM database with 100 records 5 users accounts . Each users can only view 10 records that specific to their login. Anyway to set this up with out have to create 5 different database and get it to work with one FM DB?

 

users   no of records

A         10 records

B         20 records

C          5 records

D          5 records

E        60 records    

If I understand correctly you could use a portal, filtered by user name or a login script which finds the user by their account name.

The simplest way to do this is to make a field on the records that is set to put the account name on creation in the field (Unless you are using some other method of deciding who can see what record). Then I would just do an on record load script trigger to omit any records that don't belong to the account name that is currently logged in. 

Does anyone know of a recommended way of display data specific to one user login.  Each users can only view 10 records that specific to their login.

 

Hi John,

 

This is precisely the purpose of Security - control User access according to their login.  You can create a privilege set which restricts records to custom setting according to your criteria, such as 'who created the record' as Voltron suggests.  In this way, FM will do the work for you - restricting records produced when performing a find, restricting records displayed in a portal ...

 

You need to also control Show All Records and Show Omitted (which you would need to control anyway).  You can read up on the various techniques in the Security Concepts forum.