Administrative API Reference

SQL-AUTHORIZATIONS

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 17. 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_LOAD_AUTH LOAD 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.
SQL_LOAD_GRP_AUTH User belongs to a group which holds LOAD authority.
Note:SYSADM, SYSMAINT, and SYSCTRL are only indirect authorities and cannot be granted directly to the user. They are available only through the groups to which the user belongs.

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;
  short           sql_load_auth;
  short           sql_load_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.
    05 SQL-LOAD-AUTH PIC S9(4) COMP-5.
    05 SQL-LOAD-GRP-AUTH PIC S9(4) COMP-5.
*

[ Top of Page | Previous Page | Next Page ]