Controlling Access at the System, Database, and Table Levels

Restriction: This topic applies to Windows environments only.

The database administrator is responsible for protecting the security of the system, locations, databases, and tables. This is accomplished by creating and deleting AuthIDs (user names) and groups, as well as granting and revoking privileges at various levels within the system.

Activate security privileges by turning security on with the XDB Server Configuration utility. Use the SQLWizard (Windows) or Interactive SQL (UNIX) to add and delete AuthIDs. See the chapter Security and Authority for more information.

Privileges on system functions and database objects are managed through the SQL GRANT and REVOKE commands, which are described in the SQL Reference.