DB2 Express - DB2Admin User can not access tables

Use este forum para coisas que não tem nada a ver com Oracle.
Post Reply
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Guys,

I understand that this forum is more focused on the Oracle Bank, but if someone of you know DB2, I would appreciate if you could give me a tip.

I need to do a DB2-> Oracle migration study and in this sense I installed DB2 Express-C (Release 10) on my Windows XP machine. Express corresponds to a free version of DB2, such as Oracle XE.

With the default / default installation, a sample name bank was created. Only my DB2Admin installer can not access the tables of this sample bank. It informs you that you do not have access privileges.

Is there any way to allow DB2Admin to see any instance table? I understand that this would not be recommended, but the fact is that I want to study a bit of DB2 and test some tools for migration, such as Oracle SQLDeveloper and Toad for DB2.

grateful for any tips that can pass me.

Sergio Coutinho
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 13 guests