-164 authorization-id DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION qualifier-name
Explanation
An attempt was made to create a view, but the authorization ID that was used lacks the authority to create views with other qualifiers. Only an authorization ID that holds SYSADM or DBADM authority can create views for other authorization IDs.
- authorization-id
- The authorization ID that was used for the CREATE VIEW statement.
- qualifier-name
- The qualifier that was specified in the CREATE VIEW statement.
System action
The statement cannot be processed. The specified view is not created.
Programmer response
Do not attempt to create views with other than your own ID as a qualifier. The DBADM privilege should be granted on any of the databases that contain at least one of the tables on which this CREATE VIEW is based. For the view to be created successfully, system DBADM should have DATAACCESS authority or select privilege on the tables on which this CREATE VIEW is based.
SQLSTATE
42502