Scriptology Logo: FileMaker Templates, Resources & Tools
The Permissions Template is an Electronic Download

"If your database users
can click on anything...

Do you REALLY know
what will happen?"

Watch this video right now (Permissions Template Overview Movie) for a quick overview of what the Permissions Template for FileMaker will do for your own solutions. It's a quick 10 minutes and will get you started down the right path of FileMaker permissions management. Click for a movie overview of the Permissions Template

"All I want is one single, easy-to-use
place where I can control
what users can do in my database."

This was what I found myself saying over and over and over again. Each time I started to edit my own database, I had to keep in mind which scripts were associated to which buttons and how I was controlling who could click on them. I knew I could use the Get(PrivilegeSetName) function and there's always the Get(AccountName) function, I've used them both, but I just wanted to make it so Mary, Bob and Tom (but no one else) could click on the Authorize Credit Card button. The problem was that each person had a different level of access according to their different Privilege Sets.

Then there's the case where I have to reinvent the wheel each time I start a new database project. It would be much easier to simply have a standardized system which I could take from file to file and use over and over again.

Centralized management at last!

In the Permissions Template, there's one single screen used to manage all users, groups and permissions. This is probably the most valuable aspect of this template. Building a system which makes it easy to manage complex data is probably one of the harder things to accomplish in a FileMaker database.

This single management interface provides the database manager with a single point of management for controlling who can perform certain actions in the database. After you've copied the layout from the template into your own solution you can modify and enhance it as needed. You can also integrate it with login/logout tracking and any other user related activities - such as tracking the changes and records any given user has created or modified.

"Your templates always surprise me with how much attention to detail you provide. Of course the quality of the work is top notch and I rarely can think of a better approach. When looking at the Permissions Template, I was happy to see that you made it so much easier to manage things.

I think this one is a keeper."

Steve M. (in-house developer)

FileMaker's Privilege Sets are painful, aren't they?

Let's face it, if you treat Privilege Sets as groups, then management across a number of users becomes quite cumbersome. Not to mention the loss of cumulative permissions control. Huh? "cumulative permissions control". Yeah, all this means is that any user can be a member of any number of groups and they will acquire the permissions of any group they belong to - FileMaker doesn't do this all by itself. Beyond this pain, if you have to continuously drill down the myriad of dialog boxes in the Accounts & Privileges area, just to manage which privilege sets can control who can execute which scripts, it gets quite maddening.

The biggest advantage is... well,

Saving time is one that comes to mind. You can spend many weeks or months, depending on your current level of development skill, trying to figure out an efficient way of controlling which users can click on which buttons. Of course, I'm not going to insult your intelligence and assume you don't know how to use an If[] statement within a script. It's more than that. It's creating something that is both flexible and universal to your solution. Something as easy as

If[User has permission 'Authorize Credit Card'] then run Credit Card script

What you may not know is how to streamline a universal system which will work for your whole solution and cover every aspect from running navigation scripts to individualized privileged operations.

Here's a little secret, it turns out, the data solution to successfully managing users, groups and permissions can be accomplished with a minimal set of tables and relationships. The trick is successfully putting these together and providing a powerful user-interface which makes things easy to manage. Ultimately, you want a system which is portable to new solutions and old, you also want one which provides the greatest level of flexibility without compromising overall security. Allow me to show you how this can be done - using the Permissions Template.

"For years, I've been using my own system for controlling what users do. After looking at your template, I think I'm going to have to redo a lot of things to make it easier. Your approach is definitely streamlined..."

Thomas G.

"But I read somewhere that Mr. Security expert
says it's bad to "add on"
extra systems to a FileMaker database."

Don't worry. What Mr. Security expert is typically referring to are systems that attempt to recreate the user management aspect of FileMaker - including passwords. This template doesn't do that. It enhances your management of permissions by adding a level that FileMaker's security does not provide - Groups. Yes, Mr. Security expert will say that Privilege Sets are groups, but that's not really true. A real group is where you can belong to the Junior Administrators and the Accounting group and you get the permissions assigned to both groups.

With Privilege Sets, you only get the values assigned to one of them, whichever is highest in the order they appear in the Accounts and Privileges dialog box.

Another thing that Mr. Security expert is not telling you is that all across the Internet and in many other systems that use databases, the database stores the user name as plain text and encrypts the password as a hash. The Permissions Template does exactly this same thing. It leaves the password management up to FileMaker so everything is protected and secure.

"This is not Access Security, it's Permissions"

A common misperception, about enhancing FileMaker with systems which provide easier user/permissions management, revolves around creating security holes. The fact is, when it comes to accessing the database, the data and performing certain operations it's still your responsibility to be informed about how FileMaker's security and access works. The Permissions template, as does any implementation of any form of programming, implements functionality which increases the ease of management. The degree to which it creates security issues is only based on the use and implementation of such programming.

Besides, security's not compromised, it's enhanced

The Permissions template does not attempt to replicate the security provided by FileMaker. In fact, it takes advantage of it and enhances your level of control by making the management aspect easier. NO PASSWORDS ARE STORED in any data tables. Nor is it suggested that you ever do this. Why? Because FileMaker already does a good job with passwords. It stores them in an encrypted format known as a "hash". This makes it very difficult for hackers to "dig out" the passwords - at least over the network. I won't start to worry you now, but there's VERY few systems that can't be hacked when the hacker gets hold of the file. Ultimately, because no passwords are stored by the Permissions template, you have nothing to worry about.

"Thank you so much for providing the PDF files and videos for showing how to integrate your template. I've had mixed experiences with buying premade templates before.

I always like using things that make it easier to get features into my database, provided I'm comfortable with them. Your videos made it more reassuring by helping me understand everything that's going on in the template... Nice work."

Susan Lewinstein


Click on the image you wish to see. Leave the window open and click on another image to have that image loaded in the same window or you can use the Screen Shots Slideshow.

Get your full-access copy of the Permissions Template within minutes!

I've done everything I can to make this system both easy-to-use and easy-to-implement. If you're a genius FileMaker developer and master programmer then, Yes, you could take the time to replicate what the Permissions Template provides. The question I might ask is "Why?".

One of the most valuable lessons I've learned is that I can take the time to develop my own system or I can take advantage of the concept of leverage. Leverage is based off working around something that already exists. Whether it's an Internet shopping cart solution or a Permissions Template, if the work has been done then it all comes down to the issue of whether it takes more time to learn what you can leverage or learn enough to build your own.

When it comes to the Permissions Template you can't beat the time I'll save you by watching the videos and following the 12 step instructions.

The Permissions Template is only $129.00

Requires FileMaker version 8.5 or higher.

Click here to
Order the Permissions Template
and you'll be able to download the product as soon as you see the confirmation page!

Still need to see more? How about the actual product...

Click Here to Download the demo file

P.S. I'm always working on ways to make it easier to do things in FileMaker Pro. This template is something I use in my own database systems. It's not something I created just so I could sell you something. I value information and templates that save me time. My goal is always to provide the same. If you're looking for a way to manage what users can and can't do in your database file then I'm confident you'll find immediate value in this product.

If you don't think the template, the videos and documentation are worth their value then I'm offering a 100% satisfaction guarantee. If you don't use the product within a period of 30 days you can request a refund by simply mentioning why you haven't used it.


Matt Petrowsky

© 2009 Scriptology
ISO Productions, Inc.
28661 Via Las Flores #308, Murrieta, CA 92563
Phone (877) 300-2228 Fax (909) 494-4238