VMS Help  —  SQLMOD72  Arguments  AUTHORIZATION
    Specifies the authorization identifier for the module. If you do
    not specify a schema authorization, the authorization identifier
    is the user name of the user compiling the module.

    If you want to comply with the ANSI/ISO SQL89 standard, specify
    the AUTHORIZATION clause without the schema-name. Specify both
    the AUTHORIZATION clause and the schema name to comply with the
    ANSI/ISO SQL99 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 ALIAS and SCHEMA clauses 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 specify
    the RIGHTS clause in the module file. The RIGHTS 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