If you
have the proper privilege,
create synonym <synonym_owner>.<synonym_name> for
<table_owner>.<table_name>;
Be
warned, Oracle's OS authentication is extremely easy to
spoof.
Ian
MacGregor
Stanford Linear Accelerator Center
-----Original Message-----
From: Seefelt, Beth [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
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
