The following list shows the possible SECMAINT privileges
or authorities.
- 0x00000000000000000000000000000001 Control Table
- Control privilege granted or revoked on or from a table or view.
- 0x00000000000000000000000000000002 ALTER
- Privilege granted or revoked to alter a table or sequence.
- 0x00000000000000000000000000000004 ALTER with GRANT
- Privilege granted or revoked to alter a table or sequence with
granting of privileges allowed.
- 0x00000000000000000000000000000008 DELETE TABLE
- Privilege granted or revoked to drop a table or view.
- 0x00000000000000000000000000000010 DELETE TABLE with GRANT
- Privilege granted or revoked to drop a table with granting of
privileges allowed.
- 0x00000000000000000000000000000020 Table Index
- Privilege granted or revoked on or from an index.
- 0x00000000000000000000000000000040 Table Index with GRANT
- Privilege granted or revoked on or from an index with granting
of privileges allowed.
- 0x00000000000000000000000000000080 Table INSERT
- Privilege granted or revoked on or from an insert on a table or
view.
- 0x00000000000000000000000000000100 Table INSERT with GRANT
- Privilege granted or revoked on or from an insert on a table with
granting of privileges allowed.
- 0x00000000000000000000000000000200 Table SELECT
- Privilege granted or revoked on or from a select on a table.
- 0x00000000000000000000000000000400 Table SELECT with GRANT
- Privilege granted or revoked on or from a select on a table with
granting of privileges allowed.
- 0x00000000000000000000000000000800 Table UPDATE
- Privilege granted or revoked on or from an update on a table or
view.
- 0x00000000000000000000000000001000 Table UPDATE with GRANT
- Privilege granted or revoked on or from an update on a table or
view with granting of privileges allowed.
- 0x00000000000000000000000000002000 Table REFERENCE
- Privilege granted or revoked on or from a reference on a table.
- 0x00000000000000000000000000004000 Table REFERENCE with GRANT
- Privilege granted or revoked on or from a reference on a table
with granting of privileges allowed.
- 0x00000000000000000000000000020000 CREATEIN Schema
- CREATEIN privilege granted or revoked on or from a schema.
- 0x00000000000000000000000000040000 CREATEIN Schema with GRANT
- CREATEIN privilege granted or revoked on or from a schema with
granting of privileges allowed.
- 0x00000000000000000000000000080000 DROPIN Schema
- DROPIN privilege granted or revoked on or from a schema.
- 0x00000000000000000000000000100000 DROPIN Schema with GRANT
- DROPIN privilege granted or revoked on or from a schema with granting
of privileges allowed.
- 0x00000000000000000000000000200000 ALTERIN Schema
- ALTERIN privilege granted or revoked on or from a schema.
- 0x00000000000000000000000000400000 ALTERIN Schema with GRANT
- ALTERIN privilege granted or revoked on or from a schema with
granting of privileges allowed.
- 0x00000000000000000000000000800000 DBADM Authority
- DBADM authority granted or revoked.
- 0x00000000000000000000000001000000 CREATETAB Authority
- Createtab authority granted or revoked.
- 0x00000000000000000000000002000000 BINDADD Authority
- Bindadd authority granted or revoked.
- 0x00000000000000000000000004000000 CONNECT Authority
- CONNECT authority granted or revoked.
- 0x00000000000000000000000008000000 Create not fenced Authority
- Create not fenced authority granted or revoked.
- 0x00000000000000000000000010000000 Implicit Schema Authority
- Implicit schema authority granted or revoked.
- 0x00000000000000000000000020000000 Server PASSTHRU
- Privilege granted or revoked to use the pass-through facility
with this server (federated database data source).
- 0x00000000000000000000000040000000 ESTABLISH TRUSTED CONNECTION
- Trusted connection was created
- 0x00000000000000000000000100000000 Table Space USE
- Privilege granted or revoked to create a table in a table space.
- 0x00000000000000000000000200000000 Table Space USE with GRANT
- Privilege granted or revoked to create a table in a table space
with granting of privileges allowed.
- 0x00000000000000000000000400000000 Column UPDATE
- Privilege granted or revoked on or from an update on one or more
specific columns of a table.
- 0x00000000000000000000000800000000 Column UPDATE with GRANT
- Privilege granted or revoked on or from an update on one or more
specific columns of a table with granting of privileges allowed.
- 0x00000000000000000000001000000000 Column REFERENCE
- Privilege granted or revoked on or from a reference on one or
more specific columns of a table.
- 0x00000000000000000000002000000000 Column REFERENCE with GRANT
- Privilege granted or revoked on or from a reference on one or
more specific columns of a table with granting of privileges allowed.
- 0x00000000000000000000004000000000 LOAD Authority
- LOAD authority granted or revoked.
- 0x00000000000000000000008000000000 Package BIND
- BIND privilege granted or revoked on or from a package.
- 0x00000000000000000000010000000000 Package BIND with GRANT
- BIND privilege granted or revoked on or from a package with granting
of privileges allowed.
- 0x00000000000000000000020000000000 EXECUTE
- EXECUTE privilege granted or revoked on or from a package or a
routine.
- 0x00000000000000000000040000000000 EXECUTE with GRANT
- EXECUTE privilege granted or revoked on or from a package or a
routine with granting of privileges allowed.
- 0x00000000000000000000080000000000 EXECUTE IN SCHEMA
- EXECUTE privilege granted or revoked for all routines in a schema.
- 0x00000000000000000000100000000000 EXECUTE IN SCHEMA with GRANT
- EXECUTE privilege granted or revoked for all routines in a schema
with granting of privileges allowed.
- 0x00000000000000000000200000000000 EXECUTE IN TYPE
- EXECUTE privilege granted or revoked for all routines in a type.
- 0x00000000000000000000400000000000 EXECUTE IN TYPE with GRANT
- EXECUTE privilege granted or revoked for all routines in a type
with granting of privileges allowed.
- 0x00000000000000000000800000000000 CREATE EXTERNAL ROUTINE
- CREATE EXTERNAL ROUTINE privilege granted or revoked.
- 0x00000000000000000001000000000000 QUIESCE_CONNECT
- QUIESCE_CONNECT privilege granted or revoked.
- 0x00000000000000000004000000000000 SECADM Authority
- SECADM authority granted or revoked
- 0x00000000000000000008000000000000 USAGE Authority
- USAGE privilege granted or revoked on or from a sequence
- 0x00000000000000000010000000000000 USAGE with GRANT Authority
- USAGE privilege granted or revoked on or from a sequence with
granting of privileges allowed.
- 0x00000000000000000020000000000000 WITH ADMIN Option
- WITH ADMIN Option is granted or revoked to or from a role.
- 0x00000000000000000040000000000000 SETSESSIONUSER Privilege
- SETSESSIONUSER granted or revoked
- 0x00000000000000000080000000000000 Exemption
- Exemption granted or revoked
- 0x00000000000000000100000000000000 Security label
- Security label granted or revoked
- 0x00000000000000000200000000000000 WRITE with GRANT
- Privilege granted or revoked to write a global variable with granting
of privileges allowed.
- 0x00000000000000000400000000000000 Role Membership
- Role membership that is granted or revoked
- 0x00000000000000000800000000000000 Role Membership with ADMIN
Option
- Role membership with ADMIN Option that is granted or revoked
- 0x00000000000000001000000000000000 READ
- Privilege granted or revoked to read a global variable.
- 0x00000000000000002000000000000000 READ with GRANT
- Privilege granted or revoked to read a global variable with granting
of privileges allowed.
- 0x00000000000000004000000000000000 WRITE
- Privilege granted or revoked to write a global variable.
- 0x00000000000000010000000000000000 SQLADM
- SQLADM authority granted or revoked.
- 0x00000000000000020000000000000000 WLMADM
- WLMADM authority granted or revoked.
- 0x00000000000000040000000000000000 EXPLAIN
- EXPLAIN authority granted or revoked.
- 0x00000000000000080000000000000000 DATAACCESS
- DATAACCESS authority granted or revoked.
- 0x00000000000000100000000000000000 ACCESSCTRL
- ACCESSCTRL authority granted or revoked.
- 0x00000000000000200000000000000000 CREATE_SECURE_OBJECT
- CREATE_SECURE_OBJECT authority granted or revoked.
DB2 10.5 for Linux, UNIX, and Windows