Database Utilities (MOSC)

MOSC Banner

ORA-39109: Unprivileged users may not operate upon other users' schemas

edited May 19, 2017 5:01AM in Database Utilities (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center