Removing Admin access to databases (FileMaker Pro Advanced)FileMaker Pro and FileMaker Pro Advanced use accounts, privilege sets, and extended privileges to protect FileMaker databases. You can use the Developer Utilities to remove all administrative accounts from a file. For more information about accounts and privileges, see Protecting databases.Important Selecting this option permanently deletes from the database all accounts that were using the Full Access privilege set. This will permanently eliminate access to Layout mode and the Manage Scripts feature, except for the Extended Privileges tab of the Manage Security dialog box, for all database files in the solution, whether they’re opened in a runtime application, in FileMaker Pro, or in FileMaker Pro Advanced. Structural and design elements of the files cannot be modified by anyone, including FileMaker employees. The only way to modify the tables, field definitions, relationships, scripts, or access privileges is by returning to the original file before it was customized by the Developer Utilities.
2.
3. If you have used the Developer Utilities on the same database before and saved your settings, click Load Settings.
4. Click Add to locate the files that you want to customize.
6.
7. For Solution Options, click Specify. See Specifying options for developer solutions (FileMaker Pro Advanced).
8. This prevents users from altering the design and structure of your database files and from changing any accounts or privileges that you’ve set up.
• When the Remove admin access from files permanently option is enabled:
• Users can’t access these dialog boxes: Manage Database, Manage External Data Sources, Manage Custom Functions, and most of Manage Security.
• Users can access the Extended Privileges tab in Manage Security if their account has the Manage extended privileges option enabled.
• Users can access the dialog boxes listed above if they run a script with the Run script with full access privileges option enabled.
• Users can access Layout mode and the Manage Scripts feature if the privilege set assigned to their account permits it.
• All database files must have at least one active account or they can’t be opened. You can’t use the Remove admin access from files permanently option if the accounts with Full Access privilege sets are the only active accounts in the file. If you attempt to do so, you will receive an error message.
• Consider the long-term needs of your users when defining access privileges. Communicate their access privileges to them clearly in the About layout and follow the rules specified by FileMaker. For more information, see Documenting developer solutions (FileMaker Pro Advanced).