Library /sys$common/syshlp/SQL$HELP72.HLB  —  DECLARE  MODULE  Arguments  AUTHORIZATION
    Specifies the authorization identifier for the module. If you
    do not specify a schema clause, the authorization identifier
    specifies the default schema.

    To comply with the ANSI/ISO 1989 standard, specify the
    AUTHORIZATION clause without the schema name. Specify both the
    AUTHORIZATION clause and the schema name to comply with the
    ANSI/ISO SQL standard.

    When you attach to a multischema database, the authorization
    identifier for each schema is the user name of the user compiling
    the module. This authorization identifier defines the default
    alias and schema. You can use the SCHEMA clause and the DECLARE
    ALIAS statement to override the defaults.

    If you attach to a single-schema database or specify that
    MULTISCHEMA IS OFF in your ATTACH or DECLARE ALIAS statements
    and you specify both an AUTHORIZATION clause and an ALIAS clause,
    the authorization identifier is ignored by SQL unless you use
    the RIGHTS RESTRICT clause. The RIGHTS RESTRICT clause causes
    SQL to use the authorization identifier specified in the module
    AUTHORIZATION clause for privilege checking.

    If procedures in the SQL module always qualify table names with
    an authorization identifier, the AUTHORIZATION clause has no
    effect on SQL statements in the procedures.

    When the FIPS flagger is enabled, the omission of an
    AUTHORIZATION clause is flagged as nonstandard ANSI syntax.
Close Help