Using advanced tools > Setting up files for developer solutions > Removing Admin access to databases

Removing Admin access to databases

Note  This feature is available when the Use advanced tools general preference is selected. See Using advanced tools.

You can use the Developer Utilities to remove all administrative account access from a file.

Important  Selecting this option permanently deletes from the database all account access entries that were using the Full Access privilege set. This includes all database files in the solution, whether opened in a runtime application or in FileMaker Pro Advanced. Structural and design elements of the files cannot be recovered. The only way to modify the tables, field definitions, relationships, scripts, or all access privileges is by returning to the original file before it was customized by the Developer Utilities.

To remove Admin access to a database:

1. Close all of your database files that you are going to customize.

2. Choose Tools menu > Developer Utilities.

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.

5. If you add multiple files, double-click a file in the list to specify the primary file.

6. Select Developer Utilities settings as required. See Setting up files for developer solutions.

7. For Solution Options, click Specify. See Specifying options for developer solutions.

8. Select Remove admin access from files permanently and click OK.


When you remove admin access:

Users can't access these dialog boxes: Manage Database, Manage External Data Sources, Manage Custom Functions, some Manage Security and most Advanced Security Settings.

Users can access the dialog boxes listed above if they run a script that is set to run with full access privileges. See Creating and editing scripts.

The text version of custom functions is removed.

Users can access the Manage Security dialog box if their account access has the Manage accounts that don't have Full Access privilege enabled. See Editing other privileges.

Users can access the Extended Privileges tab in Advanced Security Settings dialog box if their account access has the Manage extended privileges privilege enabled.

Users can access Layout mode and the Script Workspace if the privilege set assigned to their account permits it.

Users can't use the Developer Utilities to remove or change the encryption password for an encrypted file.

Related topics 

Managing security

Binding files into a runtime solution

About creating runtime solutions

Displaying databases in Kiosk mode