auth-id1 DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION authorization-ID

Conclusão: The authorization ID auth-id1 does not have the authority necessary to create views with qualifiers other than its own authorization ID. Specifically, the attempt to create a view with qualifier authorization-ID is rejected.

Ação do sistema: The statement cannot be executed. The specified view was not created.

Resposta ao Desenvolvedor: Do not attempt to create views with other than your own ID as a qualifier. Only an authorization ID that holds 'SYSADM' or 'DBADM' authority can create views for other authorization IDs. 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.

SQLSTATE: 42502