This structure is used to return information after a call to sqluadau - Get Authorizations. The data type of all fields is SMALLINT. The
first half of the following table contains authorities granted directly to a
user. The second half of the table contains authorities granted to the
groups to which a user belongs.
Table 15. Fields in the SQL-AUTHORIZATIONS Structure
| Field Name | Description | ||
|---|---|---|---|
| SQL_AUTHORIZATIONS_LEN | Size of structure. | ||
| SQL_SYSADM_AUTH | SYSADM authority. | ||
| SQL_SYSCTRL_AUTH | SYSCTRL authority. | ||
| SQL_SYSMAINT_AUTH | SYSMAINT authority. | ||
| SQL_DBADM_AUTH | DBADM authority. | ||
| SQL_CREATETAB_AUTH | CREATETAB authority. | ||
| SQL_CREATET_NOT_FENC_AUTH | CREATE_NOT_FENCED authority. | ||
| SQL_BINDADD_AUTH | BINDADD authority. | ||
| SQL_CONNECT_AUTH | CONNECT authority. | ||
| SQL_IMPLICIT_SCHEMA_AUTH | IMPLICIT_SCHEMA authority. | ||
| SQL_SYSADM_GRP_AUTH | User belongs to a group which holds SYSADM authority. | ||
| SQL_SYSCTRL_GRP_AUTH | User belongs to a group which holds SYSCTRL authority. | ||
| SQL_SYSMAINT_GRP_AUTH | User belongs to a group which holds SYSMAINT authority. | ||
| SQL_DBADM_GRP_AUTH | User belongs to a group which holds DBADM authority. | ||
| SQL_CREATETAB_GRP_AUTH | User belongs to a group which holds CREATETAB authority. | ||
| SQL_CREATE_NON_FENC_GRP_AUTH | User belongs to a group which holds CREATE_NOT_FENCED authority. | ||
| SQL_BINDADD_GRP_AUTH | User belongs to a group which holds BINDADD authority. | ||
| SQL_CONNECT_GRP_AUTH | User belongs to a group which holds CONNECT authority. | ||
| SQL_IMPLICIT_SCHEMA_GRP_AUTH | User belongs to a group which holds IMPLICIT_SCHEMA authority. | ||
| |||
Language Syntax
C Structure
/* File: sqlutil.h */
/* Structure: SQL-AUTHORIZATIONS */
/* ... */
SQL_STRUCTURE sql_authorizations
{
short sql_authorizations_len;
short sql_sysadm_auth;
short sql_dbadm_auth;
short sql_createtab_auth;
short sql_bindadd_auth;
short sql_connect_auth;
short sql_sysadm_grp_auth;
short sql_dbadm_grp_auth;
short sql_createtab_grp_auth;
short sql_bindadd_grp_auth;
short sql_connect_grp_auth;
short sql_sysctrl_auth;
short sql_sysctrl_grp_auth;
short sql_sysmaint_auth;
short sql_sysmaint_grp_auth;
short sql_create_not_fenc_auth;
short sql_create_not_fenc_grp_auth;
short sql_implicit_schema_auth;
short sql_implicit_schema_grp_auth;
};
/* ... */
|
COBOL Structure
* File: sqlutil.cbl
01 SQL-AUTHORIZATIONS.
05 SQL-AUTHORIZATIONS-LEN PIC S9(4) COMP-5.
05 SQL-SYSADM-AUTH PIC S9(4) COMP-5.
05 SQL-DBADM-AUTH PIC S9(4) COMP-5.
05 SQL-CREATETAB-AUTH PIC S9(4) COMP-5.
05 SQL-BINDADD-AUTH PIC S9(4) COMP-5.
05 SQL-CONNECT-AUTH PIC S9(4) COMP-5.
05 SQL-SYSADM-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-DBADM-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-CREATETAB-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-BINDADD-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-CONNECT-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-SYSCTRL-AUTH PIC S9(4) COMP-5.
05 SQL-SYSCTRL-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-SYSMAINT-AUTH PIC S9(4) COMP-5.
05 SQL-SYSMAINT-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-CREATE-NOT-FENC-AUTH PIC S9(4) COMP-5.
05 SQL-CREATE-NOT-FENC-GRP-AUTH PIC S9(4) COMP-5.
05 SQL-IMPLICIT-SCHEMA-AUTH PIC S9(4) COMP-5.
05 SQL-IMPLICIT-SCHEMA-GRP-AUTH PIC S9(4) COMP-5.
*
|