Import External Data Wizard Needs Strange (For Me) Privilege

[MickeyMiner]

Hi,

We have very strict security restrictions within our company. I face difficulties importing data from Oracle into MySQL. Could you please help me solving my problem?

We have one Oracle machine (192.168.200.10), one MySQL machine (192.166.100.20) and my localhost with SQLyog on it (192.168.200.30). While working with SQLyog I try to import data from Oracle into MySQL via ODBC. I receive the message “ERROR: 1044, Access denied for user 'mickey'@'192.166.%' to database 'my_project'”

Why do I need this privilege? I was given the privilege 'mickey'@'192.168.%' to connect from my localhost, but who is opening this connection? How are the data transferred? Oracle -> SQLyog/localhost -> MySQL? Or some other way?

Thank you for your help.

mm

[Khushboo]

Hi,

We will look into this issue. In the mean while, please reply to these queries:

1. Are you able to connect to MySQL server at 192.166.100.20, using username 'mickey' through SQLyog at 192.168.200.30. (Please

2. If you are connected successfully, can you see database “my_project” in SQLyog's Object Browser? You can also execute “Show Databases” to check if you have access to this database.

Thank You.

Regards,

Khushboo

[MickeyMiner]

Hi,

thank you for a prompt response.

'Khushboo' wrote on '18:

2. If you are connected successfully, can you see database “my_project” in SQLyog's Object Browser? You can also execute “Show Databases” to check if you have access to this database.

Yes. I have the rights to see my databases (including my_project), their tables, triggers, structures and data. I have no rights to change the structures though.

I have just talked to our admins. They had to give me create table rights to migrate the data. But they have revoked them immediately after I was ready… This seems to be a bug in SQLyog, that I need more rights than necessary to simply make some inserts…

m.

[Khushboo]

Quote:

I have just talked to our admins. They had to give me create table rights to migrate the data.

To import successfully, the privileges required on target table depend upon the options selected in Import External Data –> Advanced Options (see the screen shot).

Please check what options you have selected? You can also attach a screenshot here.

Thank You.

Regards,

Khushboo

[Author]

Posts