Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: create synonym for other acct without logging to the user

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

From: grace lim <mglim_at_softhome.net>
Date: Fri, 11 Aug 2000 09:05:10 +0800
Message-Id: <10585.114325@fatcity.com>


can you provide me a sample to give me an idea..... i don't understand why i have to change password first to create a synonym that points to an object own by other account.

At 09:31 AM 8/10/00 -0800, you wrote:
>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).
Received on Thu Aug 10 2000 - 20:05:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US