I need to grant all the privileges of a user (say 'AAA') to another user (say 'BBB').
Is there such an Oracle command (220.127.116.11.0)?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
expdp userid=system directory=DATA_PUMP_DIR dumpfile=AAA.dmp schemas=AAA impdp userid=system directory=DATA_PUMP_DIR dumpfile=AAA.dmp remap_schema=AAA:BBB
or make use of dbms_metadata
You might want to look at roles here Paul...