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/
------------------------------
Be a better Heartthrob. Get better relationship answers
<http://us.rd.yahoo.com/evt=48255/*http://answers.yahoo.com/dir/_ylc=X3oDMTI5MGx2aThyBF9TAzIxMTU1MDAzNTIEX3MDMzk2NTQ1MTAzBHNlYwNCQUJwaWxsYXJfTklfMzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545433>from
someone who knows.
Yahoo! Answers - Check it out.
