I have tables owned by xxx but don't know the password for user and can't change it.

I want to login as myself aaa/aaa and dump data for schema=xxx tables=one, two, three but this is not allowed.

Is there a way to get around this? I guess I can export the whole schema and only import the data for those tables I need but the there is alot of data.

Any idea?