This topic is 1796 days old. Please don't post here. Open a new topic instead.
Our company still uses FMP 11 Advanced because hosting online via IWP is much, much cheaper than hosting with a modern version of FMP. Currently, we pay double to have two different FMP 11 databases hosted online. One database contains 900 records and is open to the public with no password, and the other has several thousand records and requires a password.
In hopes of cutting our hosting cost in half, I would like to combine the two databases into one database, such that we need only pay to host 1 database. But our need to password protect certain records remains.
In other words, I want to put the content that doesn't require a password inside the FMP database file that has data we want to protect. I know it's possible to combine the two databases, but that would mean we can no longer use a main password to lockout the entire file, as that would lock out everybody. I would like to know if I can use FMP 11 Advanced to password protect only certain records within a single database file?
By Jim Gill
I have a very old script (fmp 10?) that creates User Accounts and assigns Privilege Sets. The users are then able to Login via WebDirect (primarily). The Add Account function is used with the following parameters:
Add Account [ Account Name: _Parent Data::Parent1_Email_TrimAndRemoveReturns; Password: _Parent Data::
Parent1_WebPassword; Privilege Set: Web_User ]
[ Expire password ]
The Password is temporary (for first login only) that is randomly generated via Custom Function. Users are required to change their password on first login.
The account is created but for some reason the user cannot Login via Webdirect or Client (Invalid Account/Password). I checked the privilege sets and they all check out. I can manually change the password form the Security Console and require a new password - and everything works as expected. Again this script worked for years - we typically only create accounts in the fall - so if there has been a major security update or some other new requirement that would throw a wrench in the works - well, hoping you all can help me out.
Thank you in advance!
By Joost Miltenburg
I added security to limit the DataAPI user from accessing certain records, with the limited option. I tested this while running these files on my HD no server. Worked like a charm. After moving the files to FMServer the DataAPI account can access all record in the table all of a sudden.
Any thoughts as to why this is happening?
Hi - I'm developing a business solution to be hosted on FM Server. It will be hosted on Soliant Cloud. This is my first time developing for Server. I read Steven and Wim's whitepaper on FM 16 security, which was very helpful.
In the past, when I've created upgrades to my solution, I've imported data from the previous version into the new one. Each update is a modified version of the previous file.
I read about the benefits of using File Access Protection. My solution is a single file solution so I can basically exclude any other file having access - except I'm not sure what impact that will have on import from previous versions. I assume both files will have the same ID - but not sure if that means that FM will see the older version as trusted or not.
Our institution is now requiring PHI-containing databases to log not just modifications to records, but to log every access/viewing of any record. They want to be able to respond to the question "Who has looked at my medical record, even with no change to the record?".
I am not aware how to achieve this with FM, do any of the add-on programs have such features?
I am facing the forced elimination of a critical database, built over 15 yrs, if this cannot be achieved.
Thanks for any suggestions.