Title: RE: conversion from public to private synonym
A private synonym cannot have the same name as the object. You will have to change dependent code if your public synonym name was same as the object name.
rgds
amar
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED
to recode to get the correct table names in.
From: Amar Kumar Padhi [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: conversion from public to private synonym
Date: Wed, 29 Aug 2001 05:16:18 -0800
A private synonym cannot have
THE FOLLOWING IS A JOKE, KIDDIES, DONT TRY THIS AT HOME(OR WORK)
update sys.syn$ set type = 'PRIVATE' where name = 'SYNONYM NAME';
you can't u must drop and recreate.
joe
Seema Singh wrote:
Hi
how to change from public synonym to private synonym without droping the
synonym?
thanks
Actually, it's even easier. You can create the private synonym (which will
then take precedence over the public synonym when logged in as the synonym
owner) and then drop the public synonym. Users wouldn't even notice any
change.
Jay Miller
-Original Message-
Sent: Tuesday, August 28,