SQL$HELP72.HLB  —  User Supplied Names, Authorization Identifiers, Nonstored Modules
    A nonstored module resides outside the database in an SQL module
    file.

    The AUTHORIZATION clause specifies the authorization identifier
    for the module. If you omit the authorization identifier, SQL
    selects the user name of the user compiling the module as the
    default authorization. Thus, if you use the RIGHTS clause, SQL
    compares the user name of the person who executes a module with
    the authorization identifier with which the module was compiled
    and prevents any user other than the one who compiled that module
    from invoking that module. When you use the RIGHTS clause, SQL
    bases privilege checking on the default authorization identifier
    in compliance with the ANSI/ISO standard.
Close Help