I am trying to run a sql script on a remote database using DB2 10.1 on AIX 6.1. I have granted my admin user (Adm101) on the database server SECADM. But when i run my script on the remote server with the db2 client (Client101) I get:
SQL0552N "Client101" does not have the privilege to perform operation "CREATE TABLE". SQLSTATE=42502
Adm101 is in listed in the database but Client101 is not. How can I create a table on the remote client?
SECADM
gets, as opposed toSYSADM
, etc. See pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/…