FileMaker Calculation Functions Helpful To Secure Design

From Dwayne Wright PMP, PMI-PBA, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Calculation functions can be used when customizing privilege sets, branching which steps a script can perform, determining access to a record and of course change the results of a calculation field. Here are some of the new functions that come to mind and ways you may ( possibly ) want to use them.

Get ( AccountName ) - returns the name of the account used to open the file. The account name is authenticated and ensures the user is ... who they say they are ( within reason ).

Get ( PrivilegeSetName ) - returns the name of the privilege set associated to the account used to open the file. This can be used to branch a script, when you don't want to change everything a privilege set does. For example, you may only want to change what a particular script does for users of a privilege set temporarily.

Get ( ExtendedPrivileges) - returns the extended privilege settings in a text carriage return based format that is associated to the privilege set associated to the account used to open the file. This could be used for logging activity of a user in a script or to branch a script.

Get ( SystemNICAddress ) - looks at all the network cards in the computer and returns the hardware address of each. When used in concert with Get(AccountName), you may be able to see if someone has "shared" their account sign in information. If a particular account name is be used by multiple NIC addresses, it may indicate you have a security problem.

Get ( SystemIPAddress ) - looks at all the network cards in the computer and returns the IP address of each. Much the same as Get ( SystemNICAddress), when used in concert with Get(AccountName), you may be able to see if someone has "shared" their account sign in information. If a particular account name is be used by multiple IP addresses, it may indicate you have a security problem.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2007 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.