A tabela SYSSEQUENCEAUTH registra os privilégios que são mantidos pelos usuários nas sequências.
O esquema é SYSIBM.
The SYSSEQUENCEAUTH table records the privileges that are held by users over sequences.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| GRANTOR |
VARCHAR(128)
NOT NULL |
Authorization ID of the user who granted the privileges. |
G |
| GRANTEE |
VARCHAR(128)
NOT NULL |
Authorization ID of the user or group that holds the privileges or the name of an application plan or package that uses the privileges.
PUBLIC for a grant to PUBLIC. |
G |
| SCHEMA |
VARCHAR(128)
NOT NULL |
Schema of the sequence. |
G |
| NAME |
VARCHAR(128)
NOT NULL |
Name of the sequence. |
G |
| GRANTEETYPE |
CHAR(1)
NOT NULL |
Type of grantee:
- blank
- An authorization ID.
- L
- Role
- P
- An application plan or package. The grantee is a package if COLLID is not blank.
- R
- Internal use only.
|
G |
| AUTHHOWGOT |
CHAR(1)
NOT NULL |
Authorization level of the user from whom the privileges were received.
This authorization level is not necessarily the highest authorization level of the grantor:
- blank
- Not applicable
- E
- SECADM
- G
- ACCESSCTRL
- L
- SYSCTRL
- S
- SYSADM
- T
- DATAACCESS
|
G |
| ALTERAUTH |
CHAR(1)
NOT NULL |
Indicates whether grantee holds ALTER privilege on the sequence:
- blank
- Privilege is not held.
- G
- Privilege is held with the GRANT option.
- Y
- Privilege is held without the GRANT option.
|
G |
| USEAUTH |
CHAR(1)
NOT NULL |
Indicates whether grantee holds USAGE privilege on the sequence:
- blank
- Privilege is not held.
- G
- Privilege is held with the GRANT option.
- Y
- Privilege is held without the GRANT option.
|
G |
| COLLID |
VARCHAR(128)
NOT NULL |
If the GRANTEE is a package, its collection name. Otherwise, a string of length zero. |
G |
| CONTOKEN |
CHAR(8)
NOT NULL
FOR BIT DATA |
If the GRANTEE is a package, the consistency token of the DBRM from which the package was derived.
Otherwise, blank. |
G |
| GRANTEDTS |
TIMESTAMP
NOT NULL |
Time when the GRANT statement was executed. |
G |
| IBMREQD |
CHAR(1)
NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
For all other values, see Release dependency indicators.
The value in this field is not a reliable indicator of release dependencies. |
G |
| GRANTORTYPE |
CHAR(1)
NOT NULL WITH
DEFAULT |
Indicates the type of grantor:
- blank
- Authorization ID
- L
- Role
|
G |
| SYS_START |
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW BEGIN |
Reserved for future IBM® use. |
G |
| SYS_END |
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS ROW END |
Reserved for future IBM use. |
G |
| TRANS_START |
TIMESTAMP(12)
NOT NULL
GENERATED ALWAYS
AS TRANSACTION
START ID |
Reserved for future IBM use. |
G |
