Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [07-2006 Date Index] [Date Next] || [Thread Prev] [07-2006 Thread Index] [Thread Next]

RE: Fixing hosed grants

  • From: Paula Stankus <paulastankus@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 6 Jul 2006 09:26:58 -0700 (PDT)
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@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.




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.