synonym help

From: Steve <schen_at_prodigy.net>
Date: Fri, 2 Feb 2001 20:11:59 -0500
Message-ID: <95fln0$4mss$1_at_newssvr05-en0.news.prodigy.com>


[Quoted] [Quoted] I would like to have someone help with auto-populate synonym for hundreds of [Quoted] tables on a new db.

I had used one way like:

create public synonym ABC for ABC
/

grant insert,select,update,delete on ABC to public
/

create public synonym ACTION for ACTION
/

grant insert,select,update,delete on ACTION to public
/

and so on and so forth. But this needs to edit every table in the code. Is there any way to automate this code to search all tables, create public synonym of it and grant right on it to public?

Any help and comments are very appreciated.

Steve Received on Sat Feb 03 2001 - 02:11:59 CET

Original text of this message