No I do not want to do that.. but want to use that schema it self. actually it is somthing like alter user a = user b or somthing like this but am not able to recall now..and badly in need of the same. Thanks --- Nisar Tareen <ntareen@xxxxxxxxx> wrote: > May be following the user "a "has to do.... > > > grant execute on > 'object_name ' to b; > > No more DBA or IT from last September .. Life > is good and fun.... > > Nisar Tareen > > > > > ----- Original Message ---- > From: drumil narayan <drumilnarayan@xxxxxxxxx> > To: askdba@xxxxxxxxxxxxx > Sent: Friday, July 13, 2007 11:52:58 AM > Subject: [askdba] how to change the schema in same > session > > > Hi ganesh and et al > > How do I change the existing schema without altering > the same session. > eg. user a, user b > logged in as user a and want to execute some > privileged jobs of b without actually assigning any > grants or privilege to a. > > this is was explained bysome of our dba on lazydba > but > now am not able to find on lazydba > > kindly help..Drumil > > > --- Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote: > > > Same here ... waiting for something to happen :) > > > > On 5/17/07, Abraham Kurian <kurian24@xxxxxxxxx> > > wrote: > > > > > > Dont think , it is !! , havent seen any activity > > on this group for a long > > > time now > > > > > > > > > > > > On 5/16/07, Chirag DBA <chiragdba@xxxxxxxxx> > > wrote: > > > > > > > > Is this group still active ? > > > > > > > > -- > > > > Cheers, > > > > ------------------------ > > > > Chirag Majmundar > > > > > > > > > > > > > > > -- > > > ----------------------------------------------------------- > > http://iyertalks.blogspot.com/ > > > > > > Why delete messages? Unlimited storage is just > a click away. Go to > http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html > > > > ____________________________________________________________________________________ > Get the Yahoo! toolbar and be alerted to new email > wherever you're surfing. > http://new.toolbar.yahoo.com/toolbar/features/mail/index.php Did you know? You can CHAT without downloading messenger. Go to http://in.messenger.yahoo.com/webmessengerpromo.php/