Re: Create Table Security

Unfortunately, the second level text is not very helpful but here it is. 

Message ID . . . . . . :   CPC2206       Severity . . . . . . . :   00  
Message type . . . . . :   Completion  
Date sent  . . . . . . :   07/25/06      Time sent  . . . . . . : 13:58:54
Message . . . . :   Ownership of object CHAIN in MARK type *FILE changed.  

Cause . . . . . :   The ownership of object CHAIN in library MARK type 
*FILE
  has changed.  


Message ID . . . . . . :   CPF3224       Severity . . . . . . . :   40  
Message type . . . . . :   Diagnostic  
Date sent  . . . . . . :   07/25/06      Time sent  . . . . . . : 13:58:54
Message . . . . :   Not authorized to perform operation on file CHAIN.  
Cause . . . . . :   The requested operation was not done for file CHAIN in 
 
  library MARK because of insufficient authority to an object required to  

  perform the operation.  
Recovery  . . . :   Get the necessary authority from your security 
officer. 
  Then try the request again.  


Message ID . . . . . . :   CPF22BE       Severity . . . . . . . :   40  
Message type . . . . . :   Diagnostic  
Date sent  . . . . . . :   07/25/06      Time sent  . . . . . . : 13:58:54 
 
Message . . . . :   Function not done for user profile AMPGMR.  
Cause . . . . . :   The function could not be done for one of the users 
for 
  whom the function was requested.  
Recovery  . . . :   See the messages previously listed in the joblog. 
Correct
  the errors.  Try the command again.  


Message ID . . . . . . :   CPF2227       Severity . . . . . . . :   40  
Message type . . . . . :   Escape  
Date sent  . . . . . . :   07/25/06      Time sent  . . . . . . : 13:58:54 

Message . . . . :   One or more errors occurred during processing of 
command.
Cause . . . . . :   See previous messages.  
Recovery  . . . :   Correct the errors.  Submit the command again.  


Message ID . . . . . . :   CPI32B1       Severity . . . . . . . :   00  
Message type . . . . . :   Information  
Date sent  . . . . . . :   07/25/06      Time sent  . . . . . . : 13:58:54 

Message . . . . :   Constraint was removed.  
Cause . . . . . :   Constraint CHAINPK was removed from file CHAIN in 
library
  MARK for TYPE value *ALL, RMVCST value *RESTRICT. The parent file was *N 
in
  library *N.  


Message ID . . . . . . :   CPC32B1       Severity . . . . . . . :   00  
Message type . . . . . :   Completion  
Date sent  . . . . . . :   07/25/06      Time sent  . . . . . . : 13:58:54 
 
Message . . . . :   1 constraint(s) removed from file CHAIN.  
Cause . . . . . :   File CHAIN in library MARK had 1 of 1 constraints 
removed.
  See previous messages for the names of the constraints removed. If a  
  constraint was changed to the defined state and message CPI32B6 was 
sent, 
  the number of constraints removed will include these constraints even 
though
  they were not removed. See previous messages for the reason why 
constraints 
  were not removed.  


Message ID . . . . . . :   SQL0551       Severity . . . . . . . :   30  
Message type . . . . . :   Diagnostic  
Date sent  . . . . . . :   07/25/06      Time sent  . . . . . . : 13:58:54 
 
Message . . . . :   Not authorized to object MARK in *N type *USRPRF.  
Cause . . . . . :   An operation was attempted on object MARK in *N type   

  *USRPRF.  This operation cannot be performed without the required 
authority.
Recovery  . . . :   Obtain the required authority from either the security 
 
  officer or the object owner. If you are not authorized to a logical 
file, 
  obtain the authority to the based-on files of the logical file. Try the  
 
  operation again.