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

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Mon, 23 Jul 2007 13:52:14 -0700 (PDT)

Create a   "role" and give user  a and user b  the same  role.. 

easy and  fast thing to do. 


Nisar tareen 


----- Original Message ----
From: drumil narayan <drumilnarayan@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Sent: Monday, July 23, 2007 2:59:02 PM
Subject: [askdba] Re: how to change the schema in same session


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/


       
____________________________________________________________________________________
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, 
photos & more. 
http://mobile.yahoo.com/go?refer=1GNXIC

Other related posts: