import export and user privileges

We want to have User A to export/import User B's tables from an OLTP database to an OLAP database. Both are production databases.

The two databases are on different boxes. User B is the schema owner. User A does application development work on these two databases. User A needs to export and import several of user B's tables on a regular bases via a cron job.

In Oracle, only a privileged user can export and import another user's objects. We have no problem granting user A the EXP_FULL_DATABASE role on the OLTP side to do the export. However, on the OLAP side, granting the IMP_FULL-DATABASE role presents more risks than we are willing to take. This role contains a lot of system privileges including the create any table privilege. As a rule, we do not grant creating table privileges in our production databases.

I'd like to know if anyone out there have experienced the same problem and if there are any solutions to this other than granting these roles.

Thanks in advance.

Junlei

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 25 1999 - 10:57:09 CDT