Import from Database privileged/non-privileged user issue
I would like to create a database user with limited privileges, used for creating database links used with Import From Database operations. So I have a user in my source database with the following system privileges:
SELECT ANY TABLE
SELECT ANY DICTIONARY
EXPORT FULL DATABASE
IMPORT FULL DATABASE
It also has the CONNECT role.
On the target database I create a DB LINK connecting to the source database as the limited privilege user. What I get when I try to import through that link is:
Errors: ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user null
Exception : ORA-31631: privileges are required ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 2926 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4367 ORA-06512: at line 2
I checked Metalink and it says the source database user must have EXPORT FULL DATABASE and IMPORT FULL DATABASE in order for this to work.
OK, and what else? It looks to me like my user in the source database with limited privileges is too limited in some fashion. I have been granting and testing and I can't seem to get around this error. Can anyone help?