Server Security

Restriction: This topic applies to Windows environments only.

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.
Note: There is no password protection provided by the XDB Server Configuration utility. Anyone with access to the server can run the utility and enable or disable the security. Make sure that the server is physically secure from unauthorized access.
Parent topic: Server Configuration Parameters