Db2 (nt/unix) system views – Fortinet FortiDB User Manual

Page 22

Advertising
background image

FortiDB Version 3.2 Privilege Monitor User Guide

20

15-32000-81364-20081219

DB2 (NT/Unix) System Views

System Views

DB2 (NT/Unix) System Views

System View Name

Contents

Description

Privileges Involved

SYSIBM.SYSCOLAUTH

Column
privileges

SYSIBM.SYSDBAUTH

Database
system
privileges

SYSIBM.SYSINDEXAUTH

Index
privileges

This view contains the right
to DROP the index. The
creator of an index
automatically has this
CONTROL privilege.

SYSIBM.SYSPACKAGEAUTH

Package
privileges

A package is a database
object grouping related
procedures, functions,
associated cursors, and
variables together.

CONTROL: Provides the
ability to rebind, drop,
execute, and extend these
package privileges to
others. Only SYSADM and
DBADM authorities can
grant CONTROL privilege.

BIND: Provides the privilege
to rebind an existing
package.

EXECUTE: Provides the
privilege to execute a
package.

SYSIBM.SYSSCHEMAAUTH

Schema
privileges

Objects within a schema
are: tables, views,
indexes, packages, data
types, functions,
triggers, procedures,
and aliases

CREATEIN: Provides the
privilege to create objects
within the schema.

ALTERIN: Provides the
privilege to alter objects
within the schema.

DROPIN: Provides the
privilege to drop objects
within the schema.

Advertising