[askdba] Re: how to change the schema in same session

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 13 Jul 2007 10:00:08 -0700 (PDT)

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

Other related posts: