Home » RDBMS Server » Server Utilities » impdp getting grants and privs
impdp getting grants and privs [message #553778] Tue, 08 May 2012 08:30 Go to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
I did an export using the following parfile (see below) I want to import all the
objects associatd with this schema into another DB but I want don't want to over-write
any of the permissions such as grants.

Is there a way I can get the grants into a sql file before I do the import. If so,
can somebody provide an example.


cat exp_par

DUMPFILE=exp.dmp
LOGFILE=exp.log
DIRECTORY=DBBACKUP
schemas=t1

Report message to a moderator

Re: impdp getting grants and privs [message #553788 is a reply to message #553778] Tue, 08 May 2012 09:14 Go to previous message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I want don't want to over-write
any of the permissions such as grants.


EXCLUDE=GRANT

And INCLUDE to get the SQL of GRANTs with option METADATA_ONLY.

Regards
Michel

[Updated on: Tue, 08 May 2012 09:15]

Report message to a moderator

Previous Topic: export import
Next Topic: Merge two control files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 20:03:44 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.