PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Automatic Granting of Synonyms of tables/views when they are created/altered

edited Nov 28, 2012 8:17AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered
When a table or view is created or altered we manually execute a scripted stored procedure in Oracle that creates a 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 Peopletools or Oracle database to automate the creation of the synonyms so it is done automatically when a table or view is created or altered?

We have had a 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