logo  
Google
 

DB2 SQL-Error: -164

SQLState: 42502

Short Description: DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION ID

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. System action: The statement cannot be executed. The specified view was not created. Programmer response: 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.

 <-  BACK TO INDEX