Fortinet FortiDB User Manual

Page 23

System Views

DB2 (NT/Unix) System Views

FortiDB Version 3.2 Privilege Monitor User Guide
15-32000-81364-20081219

SYSIBM.SYSTABAUTH

Table
privileges

CONTROL: Provides the
privilege to DROP the table
or view and GRANT table or
view privileges to somebody
else.

ALTER: Provides the
privilege to add columns,
comments, primary key or
unique constraint, in order
to create triggers, and
create or drop check
constraints.

DELETE: Provides the
privilege to delete rows.

INDEX: Provides the
privilege to CREATE
INDEX.

INSERT: Provides the
privilege to INSERT rows.

REFERENCES: Provides
the privilege to CREATE or
DROP a foreign key.

SELECT: Provides the
privilege to retrieve data.

UPDATE: Provides the
privilege to change existing
entries.

SYSIBM.SYSTABSPACEAUTH

Tablespace
privileges

A SYSADM or SYSCTRL
authority can create
Tablespace and grant USE
privilege to others

Note: DB2 does not require users or groups to be defined within the database; it
depends on the underlying OS or other authentication mechanisms (e.g., DCE,
LDAP, RACF) in order to perform user authentication.