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.