Owner Names

The MicroKernel allows you to restrict access to files by specifying an owner name. Because owner names are optional, the files you use with the utility may or may not require an owner name. Owner names are case-sensitive.

Conceptually, owner names are like passwords. They are not the same as user or group names, which you can set in the PCC. For example, an owner name of "Master" is not the same as the default user Master.

For more information on owner names, see Owner Names .

With relational access, an ODBC error results if you attempt to manipulate a table that is restricted by an owner name. (For example in the PCC, if you double-click the table name or attempt to delete the table.) You can use the GRANT statement to grant access to a particular user or group, and then manipulate the table via relational access through ODBC. The Master user must supply the GRANT statement with the correct owner name.

Owner Names Tasks

You perform the following tasks pertaining to owner names:

Set or clear an owner name (page 13-24)

Setting or Clearing an Owner Name

You set an owner name to restrict access to a file. You clear an owner name to remove the access restriction.

Note
You can also use a GRANT statement to supply an owner name. See Owner Name in SQL Engine Reference. PCC currently does not provide a way to specify an owner name through the security properties of a file.

To set or clear an owner name

Click Options 4 Set - Clear Owner from the menu on the main window. The Set - Clear Owner Name dialog box appears (Figure 13-8).

Figure 13-8 Set/Clear Owner Name Dialog Box

In the MicroKernel File box, specify the file for which you want to set or clear an owner name. Then, to clear the owner name, click Clear Owner and specify the file's owner name in the Current Owner box.

To set the owner name, click Set Owner and specify the file's new owner name in the New Owner box. Select the Permit read-only access without an owner name check box to allow anyone to read-only access to the records.

Select the Encrypt data in file check box to ensure that unauthorized users do not examine your data using a debugger or a file dump utility. Only select this option if data security is important to your environment as this requires additional processing time.