PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How to Change DDL for Views

edited Jul 30, 2014 1:39PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered ✓
I would like to change the default Oracle DDL used to create views.  When a view is created, build scripts are generated using this convention:

     DROP VIEW PS_EXAMPLE_VW
     /
     CREATE VIEW PS_EXAMPLE_VW (EMPLID) AS SELECT A.EMPLID FROM PS_JOB A
     /

A problem associated with the default syntax is that permissions need to be re-established if the view is modified.  Developers ALWAYS forget to reissue grants.  I want to change the default DDL to use this syntax (so grants persist when the view is changed):

    CREATE OR REPLACE VIEW PS_EXAMPLE_VW (EMPLID) AS SELECT A.EMPLID FROM PS_JOB A

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