This topic is locked

Assign Group Permissions

12/1/2005 11:26:43 PM
ASPRunnerPro General questions
lefty author

Would like to know how to assign group permissions (option user can only see add edit his own records)to add update edit records from a database that has prior existing records that existed before setting up group permissions

Sergey Kornilov admin 12/6/2005

John,
are you asking how to assign permissions to existing records?

S
sdivine 12/17/2005

Would like to know how to assign group permissions (option user can only see add edit his own records)to add update edit records from a database that has prior existing records that existed before setting up group permissions


Hi John,

I can relate to your question as my experience is somewhat limited...however I'm very pleased with this product.
What I did was to put a field in each record that would identify the owner of that record. In my case, I called it AR. In the Login and Password table, I also put the AR field in the database. Then used the security options to define if other people could view the record and make changes, view others records but only change their own or view and edit only their own records.
Recently I took this further with some assistance to create GROUPS where a Group leader could see the team leaders files...although the Team Leader could only see his own files. This was done by inserting a GROUP field in each record and then building a separate project in another directory with the security based upon GROUP rather than individual. I had to make a GROUP LEADER access table where only those that had access could login, but it is working great.
Hope this helps in simple terms.

Steve