Create synonyms in externally authenticated user's schema
Title: 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
Re: Create synonyms in externally authenticated user's schema
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).
RE: Create synonyms in externally authenticated user's schema
Title: Create synonyms in externally authenticated user's schema 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 [EMAIL PROTECTED] -Original Message-From: Seefelt, Beth [mailto:[EMAIL PROTECTED]]Sent: Monday, May 13, 2002 1:38 PMTo: Multiple recipients of list ORACLE-LSubject: 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