Database Administration (MOSC)

MOSC Banner

Automatic Grant of Synonym's of tables/views as they are created

edited Dec 3, 2012 10:40AM in Database Administration (MOSC) 6 commentsAnswered
When a table or view is created we manually execute a scripted stored procedure that creates a public synonym to allow developers that do not have a sysadm login to be able to select from the table or view. Is there a process that can be implemented in the database to automate the creation of the synonyms so it is done automatically when a table or view is created?

We have had an Oracle automatically triggered stored procedure in the past, but found it was creating processes that did not always complete


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