User privileges

malsony · Post by **malsony** » Tue Jun 17, 2014 2:32 pm

Is there any way to make sure a user cannot edit the data created by another user of the same user group? Thanks!

mobhar · Post by **mobhar** » Tue Jun 17, 2014 2:40 pm

User ID Security secures data at record level. Protected tables must have an User ID field for identifying which user a record belongs to. The User ID field names can be different in tables though. When User ID security is enabled, users can only access their own data.

For more information, try to follow "Tutorial - Advanced Security - User ID Security" from the help file.

malsony · Post by **malsony** » Tue Jun 17, 2014 11:12 pm

Oh, thank you! I missed that...

So the user ID field is a must for the tables that I want to make sure one user can modify data created by another, right? Then is there a way to let the system automatically store the value so that the user does not have to fill it everytime? Thanks again!

mobhar · Post by **mobhar** » Wed Jun 18, 2014 12:12 am

Yes. You may simply use the related global function CurrentUserID() and assign it to the related field.

For example, in "Add" and "Edit" page, you may write your code in "Row_Inserting" and "Row_Updating" server event respectively:

$rsnew["yourfieldname"] = CurrentUserID();

Alternatively, you may select CurrentUserID() from "Auto-Update Value" under "General" column in Fields setup for "Edit" page. You may also put it in "Default Value" column under "Add Page" in Fields setup for "Add" page.

malsony · Post by **malsony** » Wed Jun 18, 2014 9:28 am

Thanks for your help!