Db2 for z/OS & Db2ZAI

Db2 for z/OS and its ecosystem

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Please vote for AHA ideas - REVOKE ... KEEP OBJECTS and ALTER synonymns to aliases

  • 1.  Please vote for AHA ideas - REVOKE ... KEEP OBJECTS and ALTER synonymns to aliases

    Posted Sun November 30, 2025 12:03 AM

    1) Simplify REVOKE by REVOKE ALL PRIVILEGES and RETAIN OBJECTS
    https://ideas.ibm.com/ideas/DB24ZOS-I-1839

    Revoke everything from a user, while keeping the objects, packages etc that they created.

    2) Allow the SQL ALTER statement to convert SYNONYMS into ALIASES
    https://ideas.ibm.com/ideas/DB24ZOS-I-1474

    Yes, I know this has been marked "Not under consideration - This idea is not considered a candidate for implementation at this time.".  However now that the deprecation of synonyms has been moved to actual end-of-life, this is now something that will save mountains of pain for clients.  The people who pay for Db2 development.  



    ------------------------------
    James Campbell
    ------------------------------


Related Content