• Ajit Deshmukh's avatar
    Implemented DDL execution enhancements for Pilot and Read schemas · ac0f4a88
    Ajit Deshmukh authored
    - Added DB_PILOT handling in schema execution rules
    - Restricted DDL execution to DB_MAIN schema only
    - Added synonym creation for DB_READ and DB_PILOT on object creation/replacement
    - Added object-specific grant handling for TABLE, VIEW, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, and TYPE
    - Granted SELECT, INSERT, UPDATE, DELETE privileges on TABLES to DB_PILOT
    - Granted SELECT privilege on TABLES, VIEWS, and SEQUENCES to DB_READ
    - Granted EXECUTE privilege on PROCEDURE, FUNCTION, PACKAGE, and TYPE objects to DB_READ and DB_PILOT
    - Added logging for schema and grant execution details
    ac0f4a88
SQLs 31.8 KB