In this post, you’ll learn about the error message -164 auth-id1 does not have the privilege to create a view with qualification in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-164 auth-id1 does not have the privilege to create a view with qualification
Reason for the Error
The authorization ID ‘auth-id’ 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.
Solution
Do not attempt to create views with other than your own ID as a qualifier. �Only an authorization ID that holds ‘SYSADM’ authority can create views for other authorization IDs.
