System table

The System table type contains user-maintainable information that pertains to the management or administration of the NAV application system. System tables are created by NAV; we cannot create System tables. However, with full developer license rights, we can modify System tables to extend their usage. With full system permissions, we can also change the data in System tables.

An example is the User table, which contains user login information. This particular System table is often modified to define special user access routing or processing limitations. Other System tables contain data on report-to-printer routing assignments, transaction numbers to be assigned, batch job scheduling, and so on. The following are examples of System tables in which definition and content can be modified. The first three relate to system security functions:

• User: The table of identified users and their security information
• Permission Set: The table containing a list of all the permission sets in the database
• Permission: The table defining what indpidual permission sets are allowed to do, based on object permission assignments
• Access Control: The table of the security roles that are assigned to each Windows Login

The following tables are used to track a variety of system data or control structures:

• Company: The companies in this database. Most NAV data is automatically segregated by company.
• Chart: This defines all of the chart parts that have been set up for use in constructing pages.
• Web Service: This lists the pages, queries, and codeunits that have been published as web services.
• Profile: This contains a list of all the actpe profiles and their associated Role Center pages. A profile is a collection of NAV users who are assigned to the same Role Center.
• User Personalization: In spite of its name, this table does not contain information about user personalization that has occurred. Instead, this table contains the link between the user ID and the profile ID, the language, company, and debugger controls. (A personalization is a change in the layout of a page by a user, such as adding or removing fields, page parts, restructuring menus, resizing columns, and so on. This information is in the User Metadata table.)

The following tables contain information about various system internals. Their explanation is outside the scope of this book:

• Send-to Program
• Style Sheet
• User Default Style Sheet
• Record Link
• Object Tracking
• Object Metadata
• Profile Metadata
• User Metadata