[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Hide SSN in layout

Posted on 2007-10-17
Medium Priority
Last Modified: 2008-08-27
Is there an easy way to hide the ssn field to make it visible to only one user.  We don't have passwords setup for all the databases, and would prefer to add a layout that only one user can see, without having to setup passwords for all 10 users.

Question by:KathyBrowning
  • 4
LVL 28

Accepted Solution

lesouef earned 1000 total points
ID: 20092844
you can prompt for a passwd in a script which leads to the given layout. this script would use a custom dialog box with the passwd feature on (to mask with * data entry). of course you must compare it with a password stored in  a global field for instance, or directly in the script. all admins will know that passwd by editing the script, but apart from them, it is safe.
LVL 28

Expert Comment

ID: 20092856
you can also link it to a given machine using its mac address...

Author Comment

ID: 20092874
Thank you lesouef.  How would you link it to a certain mac address.  What script function would you use?
LVL 28

Expert Comment

ID: 20093021
Get ( SystemNICAddress )
this returns the hardware mac address, but if yr machine has several cards, or ethernet + wifi, you'll get 2 adresses. if you disable one of them (case the wifi is on a usb port for instance) > the returned data is different, so may be worth to look for the embedded mac adress in the returned pattern to avoid this.
LVL 28

Expert Comment

ID: 20093029
can also be used in privs sets. but if you have no passwd at all, what is the persmission level of all users?

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

834 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