Database Administration (MOSC)

MOSC Banner

How to create more than one synonym at a time

edited Dec 22, 2009 2:43AM in Database Administration (MOSC) 10 commentsAnswered
I am trying to create an Oracle user for our developers with restricted access.  I have done so but they cannot directly access any of the tables in another schema without preceding prefixing the table name with the schema name. 

I want to create a synonym for all tables in the schema in question.  There are a lot of tables and I do not want to create a sysnonym for each table one by one. 

I have looked in the DBconsole, but only see a means of creating one synonym at a time. 

Oracle version is 10.2.0.4 in Windows 2003

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center