Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
I think you should do a little reading to understand what privileges SECADM gets, as opposed to SYSADM, etc. See pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/… –  Ian Bjorhovde Sep 11 '13 at 5:04

1 Answer 1

You will need to grant Client101 CONNECT and CREATETAB on database in order to be able to create a table. It may also help to grant IMPLICIT_SCHEMA as well. And depending on the version of your client, you may either need to connect with an admin ID first, or grant BINDADD to your ID so it can bind version specific system packages.

db2 connect to mydb as admin101 using "password"
db2 grant connect,createtab,implicit_schema,bindadd on database to user client101
db2 connect reset

then

db2 connect to mydb as client101 using "other_password"
db2 create table .....
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.