RE: Fixing hosed grants

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Thu, 6 Jul 2006 09:26:58 -0700 (PDT)
Message-ID: <20060706162658.9582.qmail@web33210.mail.mud.yahoo.com>

Help,    

  I have been looking this up but without much success. I wish to know how to get grants back from a full database export. I believe I can do it safely using the following:    

  userid=user/pass_at_dbase
file=/u005/restore/fulldwh.dmp
full=n
fromuser=(AUSER,BUSER)
rows=n
ignore=n
grants=y    

  Is that correct?
~                  

---

Do you Yahoo!?
 Next-gen email? Have it all with the all-new Yahoo! Mail Beta.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 06 2006 - 11:26:58 CDT