system tables can be hidden or deactivated, either to limit the number of active tables a user sees or remove tables from the default configuration that won't be used by your organization. To create a usable knowledgebase, it's best to only show relevant tables, so you may wish to hide some of the default tables in your implementation. It's usually not necessary to deactivate tables, unless you want to prevent users from performing certain actions, such as creating a record via a custom hotlink, viewing a table's reports, or selecting information from a linked field.
The Hide/Unhide and Deactivate functions correspond to the "Show table on the Toolbar?" and "Allow access to the table?" permissions in the Table Permissions wizard, respectively. Whereas the Table Permissions wizard enables you to configure table permissions for a given group, using Hide, Unhide, and Deactivate, toggles these permissions for all users.
A common scenario is to provide several user groups with access to a table, but not show that table in their navigation menu. By using the Hide function in the Setup > Tables screen, you can quickly remove the table from all groups' navigation menus. For groups that should see the table in their navigation menu, you can then individually adjust the "Show table on toolbar?" option for that group in the Table Permissions wizard.
Hiding a table does not affect the other record and field-level permissions for the table that a group has. This means they will still be able to view or edit records in the hidden table by accessing them through linked fields or related tables in other records.
Depending on your needs, you may want to hide or unhide tables from specific groups or all groups in the system.
To hide a table from a specific group:
To hide a table from all groups:
To unhide a previously hidden table for a specific group:
To unhide a previously hidden table for all groups:
Deactivating a table in the system removes access from all users, and it disables any additional functions of that table throughout the system. The Deactivate option is used to temporarily or permanently disable the table. Tables that are essential to system function do not offer the Deactivate option.
To deactivate a table:
To activate a deactivated table:
A number of effects occur when a table is deactivated:
After activating a previously deactivated table, prior functions and user permissions are restored throughout the system. For instance:
Related articles |