RE: create synonym for other acct without logging to the user

Ooohhh, I hadn't thought of that.

Jared

On Thu, 10 Aug 2000, Rachel Carmichael wrote:

> wouldn't it be easier to do the following (from a DBA account)
>
> create synonym <user2.synonym_name> for <user1.object_name>;
>
> just a thought... since in O8, if you are using password history, you CAN'T
> change the password and change it back.
>
>
>
> >From: "Thomas L. Harleman" <tharleman_at_iquest.net>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: create synonym for other acct without logging to the user
> >Date: Thu, 10 Aug 2000 09:31:29 -0800
> >
> >As a DBA, you can temporarily change a user's password. Of course, this
> >should be allowed by your corporate policy.
> >But assuming this is permitted, you can use a SQL script ( or create a
> >procedure to do the same ) to
> >1. change the user's password
> >2. create the synonym
> >3. restore the user's password
> >
> >
> >Tom Harleman
> >11080 Willowmere Dr.
> >Indianapolis, IN 46280
> >317-844-2884 Home
> >317-843-9122 Home Office
> >
> >
> >-----Original Message-----
> >Sent: Thursday, August 10, 2000 4:14 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >gurus,
> >
> >is there a way i could create a synonym of an object for other accounts
> >without actually logging to each account?
> >
> >thanks
> >--
> >Author: grace lim
> > INET: mglim_at_softhome.net
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
> >--
> >Author: Thomas L. Harleman
> > INET: tharleman_at_iquest.net
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon Received on Fri Aug 11 2000 - 17:41:36 CDT