Restrict user to only their records
I have read through the forums and have implemented how I understand this should be done but it is not working. Can someone see where I might be going wrong?
I have an expense table and expense line item table. I only want the currently logged in account user to be able to only see the records they created there and be able to edit them.
In each of these tables whenever a new record is created the field "z_RecordCreationAccount" captures the current logged in account name.
I have gone into security and have created a privilege set that under data access and design for these two tables I have have set for Record viewing this calculation: z_RecordCreationAccount = Get (AccountName).
I have created two test records one for myself and one for the testuser. When I log out and come back in as the test user and navigate to the expense detail layout I can still see the two records when I should only be able to see the testuser one. What am I missing?