Help: Create synonyms ?

I need to create synonyms for some tables to any new user I create. I would like to do this automaticly so I have thought of creating a stored procedure to do it for me.

How do I do this ?

will this work ?
---

Create Procedure Create_synonyms
  (User_Id IN VarChar2)
AS
BEGIN
  Create Synonym User_Id.<Synonym_Name> For <Table_Name>; END Create_Synonyms;
---

Can I use a Parameter in a Sql statement like this ?

Alternativly, is there another way of solving my problem?

Please help,

Martin Received on Fri Oct 30 1998 - 08:13:02 CST