Fortinet FortiDB User Manual download pdf (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.

1 2 ... 18 19 20 21 22 23 24 25 26 27 28 ... 51 52

No comments

Fortinet FortiDB User Manual Page 23