selikoff Posted March 19, 2001 Share Posted March 19, 2001 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 Link to comment Share on other sites More sharing options...
Kurt Knippel Posted March 19, 2001 Share Posted March 19, 2001 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 =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
selikoff Posted March 19, 2001 Author Share Posted March 19, 2001 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. Link to comment Share on other sites More sharing options...
selikoff Posted March 19, 2001 Author Share Posted March 19, 2001 I guess my confusion is how to do the navigational scripting. Can you give me an example? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted March 20, 2001 Share Posted March 20, 2001 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 =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8430 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now