Does anyone know how to limit which records in a database a person can access? There is already a field where the user enters his/her name, but I'm not sure how to relate this to password/groups.

Any help would be greatly appreciated!

Thanks!

Steven

quote:

---

Originally posted by selikoff:

Does anyone know how to limit which records in a database a person can access? There is already a field where the user enters his/her name, but I'm not sure how to relate this to password/groups./B]

---

Passwords and groups will not automatically limit what a person can access. You will need to build that level of security into the solution yourself.

If you already have some login method, so that you know who is sitting at the terminal, then your navigation scripting will determine what records they can access.

Start by making a detailed list of all of your various groups and what they can and cannot access. This will serve as your map for setting up the necessary scripting.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Can you explain what you're saying in simpler terms? I'm not sure exactly what you're saying.

FYI- the file is stored on the network. People access it from their individual computers.

I guess my confusion is how to do the navigational scripting. Can you give me an example?

quote:

---

Originally posted by selikoff:

Can you explain what you're saying in simpler terms? I'm not sure exactly what you're saying.

FYI- the file is stored on the network. People access it from their individual computers.

---

Look at it this way: Joe sits down at the computer, opens Filemaker, and logs into the databases. What records should he have access to?

Once you can answer this question for each and every user (hopefully by grouping them together, as in all salesmen have access to <whatever> ), you are ready to teach Filemaker what they should have access to.

Lets say that Joe is a sales rep, and you have decided that all sales reps should have access only to records that they created.

You setup you navigational scripting such that when Joe logs in, FMP finds the records that he created and displays them. Whenever Joe performs an action you make sure that it only works on records that Joe created. And so on...

Remember that computers are VERY, VERY stupid and will do exactly what, and only what you tell/allow them to do.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=