Is there a way for me to allow a set of users to insert records but no access to update/modify of records to a table?

Pls advice.

Thks.

Hi Mattan,

I think you are snookered on this one (depending on the table). If it is something like inventory transaction authorizations, there are seperate authorization tables for it. Otherwise, they can read, read/write or no authorization (down to the field level). In order to "insert" they would need "read/write" which allows update/modify. Baan IVc doesn't appear to allow for the situation you are describing.

Perhaps there is another way around it through SQL. I am not as familiar with that product, but you may be able to set up authorizations based on database user profiles.