ORA-39109: Unprivileged users may not operate upon other users' schemas
When try to do expdp on other schema, get an error. This example, user DMT is trying to export from doris user.
User DMT can export without any problem from its own schema.
grant create session, create table, create procedure, exp_full_database, imp_full_database to DMT;
grant read, write on directory CIA to DMT;
expdp dmt/...@... schemas=doris include=TABLE:\"IN \(\'PROV_ADDRESS\'\)\" directory=CIA dumpfile=TEST2.dmp logfile=TEST2.log
ORA-31631: privileges are required
ORA-39109: Unprivileged users may not operate upon other users' schemas