I have a layout in which the user should be able to access and edit a global field (for searching records), without being able to delete records (or create new records).
I can use a privilege set in Manage Security to prevent the user from adding or deleting records, but then the user can't access the global field to do a search.
I can also use a privilege set to lock down individual fields, but the permissions apply across all table occurrences, so I can't prevent the user from editing in one layout while allowing the user to edit in another.
All I really want to do is prevent the user from inadvertently deleting a record or creating spurious new records while they're searching. Any recommendations?