Server Security

The XDB Server is shipped with security turned off. If you enable security at the server, you must also enable security at each client workstation accessing the XDB Server. Otherwise, the XDB Server will reject the client logon.

Enabling security requires each user to log in to the XDB Server using a valid AuthID (user name) and password. To set AuthIDs, groups and passwords, use the Admin menu of the SQLWizard (Windows) or Interactive SQL utility to execute CREATE USER statements (UNIX). See the Security and Authority chapter, or User Administration in the SQLWizard User's Guide for more information.

If you enable security, the system will also check any privileges configured using the GRANT and REVOKE commands. For information about the GRANT and REVOKE commands, see the SQL Reference.

See the chapter Security and Authority for detailed information about how to plan and construct a security scheme.

To set the parameter on UNIX:

1. Press F3 SQL Engine Options.
2. Press F1 XDB Server Security.

To set the parameter on Windows 2000:

1. Click the General tab.
2. Mark the Server Security checkbox.