Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Compare two(2) Users

yxes2013Aug 12 2013 — edited Aug 12 2013

Hi all,

11.2.0.1

Aix 6.1

I have two databases(dev & uat) on separate servers with equal setup.

On each database I created a schema user "batchdba" and granted them same "dba" privilege.

But when I  import (impdp) the dumpfile output coming from other database which has encrypted table  and with the same command,  it runs successfully on DEV but not on UAT.

How do I compare which privilege is missing in UAT for user "batchdba". Or how do I compare privileges granted to the two schemas?

Thanks a lot,

zxy
This post has been answered by AbuFazal on Aug 12 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2013
Added on Aug 12 2013
#general-database-discussions
4 comments
1,939 views