Accounts & Privileges...but only through Scripting

[Mike Miles]

Greetings All,

I will simplify this as much as possible.

I have 3 separate Database files

1.Orders table

2.Customers table

3.Employee Table

I have 6 employees that use the solution.

A startup script locks down everything.

Without using the "built-in" Accounts & Privileges, is there a way i can have each employee "log-in" (so-to-speak), and limit there access to the three different tables listed above based upon whatever i feel they need access to? (An admin layout perhaps that toggles privilages on/off?)

I'm at a loss on this and need some real smarts.

TIA.

Mike

[Ender]

There's lots of things that could be done, but it's not clear why you wouldn't want to take advantage of the built-in accounts & privileges. It's more secure than any custom login system, and gives very granular control of access to the various elements.

[Mike Miles]

I know that i could set it up that way for my own personal use because i would know where i would want my employees to go, or not to go.

I am trying to create this so that if i gave it to another Company, they would be able to set it up however they wanted to. Each company might want different employees to have access to different database files. It needs to be customizable for different companies.

I'm thinking... maybe setup an employee access page that toggles different permissions on/of :)

Edited January 27, 2006 by Guest

[BrentHedden]

It would be too much to explain how to do this (here) in detail. I would suggest you get a copy of "FileMaker Security The Book" by Steven Blackwell. In this book, he goes through all kinds of security and login scenarios. I'm positive that this book will help you out tremendously.