How to Change DDL for Views
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