Informix

Informix

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

 View Only
  • 1.  How to alter a table become a read only one?

    Posted 15 hours ago

    Hi,

          The develop DBA want to change some tables to read only , include the DBA himself can't update/insert/delete those record also. Do anyone have experience how to implement  it in informix? The document told me "You cannot revoke privileges from yourself."

         Any suggestion are welcome.



    ------------------------------
    chuan lu
    ------------------------------


  • 2.  RE: How to alter a table become a read only one?

    Posted 15 hours ago
    Hi,

    from my perspective, this is what Infmrmix Security Policies are for.
    Have not used that, but you can find documentation here:

    Best,


    MARCUS HAARMANN