| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: create synonym for other acct without logging to the user
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).
 |
 |