[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How do you establish record level security?

Posted on 2002-03-05
6
Medium Priority
?
327 Views
Last Modified: 2010-04-27
I am trying to modify the Time Billing template that comes with Filemaker Pro 5 for work.  I don't understand how to structure the database so that a person can type in their password and it goes to only their records and only allows them to view their records.  I need a simple solution.  The security for passwords and groups doesn't seem to be or it could just be my lack of knowledge.

Tangier
0
Comment
Question by:taclarke
4 Comments
 
LVL 30

Accepted Solution

by:
weed earned 200 total points
ID: 6846015
The built in FM security only allows certain fields to be shown, not groups of fields. However, you could set up a simple script that would do a find for all the records that belong to the user that logged in. Of course that still allows users to show all fields. I would say break the database up into "user" databases. Each user has their own database with their own password. For administrative purposes you could set up a master database that contains nothing except fields that reference the user databases.
0
 

Assisted Solution

by:naubrey
naubrey earned 200 total points
ID: 6881393
Filemaker in menu "access privilages" allows you to:
1)create a group first e.g. admin, data entry, browse1 etc
2) you then create a password for each group
3) choose overview and configure:
You can nominate what group has access to
* what layouts
* what fields
click on the left hand dots to choose
accessible, non accessibly and read only.

When you test you will find that some menu items are dissabled.
Also dont't be fooled by field access. If you have bared access to a field you only get a not accessible message when you go to ALTER the data. It doesnt hide the field.
0
 
LVL 2

Expert Comment

by:KungFoolio
ID: 7252429
Don't forget that FileMaker 5.5 has record level security built in...

For earlier versions, you script the log-in to perform the find. Trick - the user name is actually the name used when FileMaker was installed. So anyone on that computer has access to those records. You must create a log-in database that checks their username/password combo, then goes to related records based on their log-in name. New records will need to use the log-in name (global) and not the system user name. This gets even more fun on the web...
0
 

Expert Comment

by:modulo
ID: 7426889
Dear: naubrey

I've rejected your proposed answer as Experts Exchange holds an experiment to work without the answer button.

See:        http://www.experts-exchange.com/jsp/communityNews.jsp
Paragraph: Site Update for Wednesday, November 06, 2002

By this rejection the Asker will be notified by mail and hopefully he will take his responsibility to finalize the question or post an additional comment.
The Asker sees a button beside every post which says "Accept This Comment As Answer" (including rejected answers) -- so if he/she thinks yours is the best, you'll be awarded the points and the grade.

Thanks !

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses
Course of the Month18 days, 5 hours left to enroll

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question