Filter
Top Products
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.