Fortinet FortiDB - Manual (Page 23)

System Views DB2 (NT/Unix) System Views
FortiDB Version 3.2 Privilege Monitor User Guide
15-32000-81364-20081219
21
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.