log on using an account with CREATE ANY SYNONYM privs and create the synonym as:
create <ntusername>.synonym for ........
|--------+-------------------------->
| | |
| | |
| | Beth.Seefelt@tet|
| | leyusa.com |
| | |
| | 05/13/2002 04:38|
| | PM |
| | Please respond |
| | to ORACLE-L |
| | |
|--------+-------------------------->
>----------------------------------------------------|
| |
| To: [EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
| Subject: Create synonyms in externally |
| authenticated user's schema |
>----------------------------------------------------|
Hi all,
When I create a new nt OS authenticated user I need to create several synonyms
in that users's schema? How can I create synonyms as that user easily?
I know that I can get them to give me their nt password and log in as them, or
create a stored procedure that executes as that user, or a user logon trigger,
but I'm hoping there is a more straight forward way to do this?
TIA,
Beth
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
