115The Windows Access Control System Table

You can use Windows Access Control system table to manage the Windows access rights of a user or group of users, and thereby control their access to Navision.

Each user's or group's Windows login has a unique security identifier (SID). In addition, each user or group has a role ID, which relates to a set of permissions within a certain company in Navision. The information displayed in the Login ID and Role Name fields is based on the login SID and role ID, respectively.

The Windows Login System Table

You use the Windows Login system table to define which Windows users and groups can log on to the system. Only those Windows users or those who are members of a Windows group that are listed here can log on. Each Windows user or group has a unique security identifier (SID). The name of the user or group that is displayed in the ID field is generated from the name of the user or group that is identified by the SID. The Name field is currently unused.

The Company System Table

The Company system table gives you an overview of the companies in your database. It contains a record for each company in your database. You can create a new company by entering a new record in this table. You can also delete a company from your database by deleting the corresponding record in the Company table.

Chapter 8. Special C/SIDE Tables

116

When you delete a company, you delete all the tables in the company and all the permissions that include this company.

The Database Key Groups System Table

The Database Key Groups system table gives you an overview of the key groups defined in your database. Each record in this table shows a key group.

. . .

Note about Key Groups

By making your keys members of key groups, you can activate or deactivate various

. . .

combinations of keys in your tables by enabling or disabling the key groups.

To enable and disable key groups:

1 Click File, Database, Information and the Database Information window appears.

2 Click Tables and the Database Information (Tables) window appears.

3 Click Key Groups and the Database Key Groups window appears:

4 Select a key group and click Enable or Disable to enable or disable it.

8.3 What Is a Virtual Table?

117

8.3 W

I

V

T

?

A virtual table contains information provided by the system. In C/SIDE you have access to a number of virtual tables. They work in much the same way as normal database tables, but you cannot change the information in them. That is, you can only read the information. Another difference is that virtual tables are not stored in the database (as normal tables are) but are computed by the system at run time.

When to Use Virtual Tables

Virtual tables give you a consistent interface to a variety of different information.

Because a virtual table can be treated just like an ordinary table, you can use the same methods to access information in virtual tables as you use when you are working with ordinary tables. For example, you can use filters to get subsets or ranges of integers or dates.

The virtual tables provide such information as:

· integers in the range – 1.000.000.000 to 1.000.000.000.

· dates within a given period.

· an overview of the operating system files.

· an overview of the logical disk drives.

· a trace of database requests from your client to the database.

· an overview of the users that are currently connected to the database.

· an overview of the operating system files that store the database.

Overview of the Virtual Tables

C/SIDE contains numerous virtual tables, including:

Using the Virtual Tables

The first of these virtual tables gives you easy access to dates, integers, information about your operating system files, and the logical drives on your computer.

Because the virtual tables are not stored in the database, you cannot view them directly. To view a virtual table, you must create a tabular form based on it.

To view a virtual table:

1 Open the Object Designer (SHIFT+F12).

2 Click Form, New and the New Form window appears:

Virtual Tables

Date, Integer, File, Drive, Monitor, Session, Database File, Table Information, Field, Server, Windows Object, Windows Group Member, SID - Account ID, User SID

Chapter 8. Special C/SIDE Tables

118

3 Select the Create a form using a wizard option and make sure you select the Tabular-Type Form:

4 In the Table field enter the name of the virtual table that you want to base the form on. Alternatively you can use the lookup button to select the table from a list of all the tables in the database. The virtual tables use the highest number range (2000000001 – 2000000203). In this example we use the Date table.

5 Click OK and the Tabular-Type Form Wizard appears:

6 Click the >> button to move all the available fields over to the Field Order field.

7 Click Preview to view the table and its contents. Alternatively, click Finish and save the form.

This is the method used in the rest of this chapter to view virtual tables.

The Date Virtual Table

This virtual table gives you easy access to days, weeks, months, quarters and years.

The Date virtual table has the following fields:

Field Comments

Period Type Days, weeks, months, quarters or years Period Start The date of the first day in the period Period End The date of the last day in the period

8.3 What Is a Virtual Table?

119