-567 bind-type AUTHORIZATION ERROR USING auth-id AUTHORITY PACKAGE = package-name PRIVILEGE = privilege
Explanation
The authorization ID given does
not have the privilege indicated, and cannot invoke the indicated
subcommand against the indicated package.
- bind-type
- Type of bind subcommand (BIND | REBIND | FREE).
- auth-id
- Authorization ID of the package owner.
- package-name
- Name of the package (location.collection.package.version)
- privilege
- Name of the privilege not held:
- BINDADD—The authority to create a new package using BIND with the ADD option.
- BIND—The authority to BIND (REPLACE) or REBIND a package.
- COPY—The authority to COPY from the indicated package
- CREATE IN—The authority to create a package in the indicated collection.
If you are using a trusted context, the token auth-id might
return a role instead of an authorization ID. A role is returned if
a role was in effect and the authorization checking is performed against
the role, rather than the authorization ID of the session, when the
condition was encountered. Otherwise an authorization ID is returned.
A role is returned in the following format as a single token:
- ROLE: role-name
System action
The indicated package is not bound, rebound, or freed.
System programmer response
The indicated privilege must be granted to the authorization ID that will become the package owner.
SQLSTATE
42501