3 Replies Latest reply on Jan 5, 2006 11:38 AM by Emmanuel Bernard

    How to enforce read-only (avoid alter table ... add constrai

    Marcel Marcel Newbie


      i'm feeling already it is a stupid question, but anyhow:

      I get following error:

      2005-11-23 17:15:20,433 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate]
      Unsuccessful: alter table datenbank_info add constraint FK6204E651F078DA14 foreign key (datenbank_id) references datenbank
      2005-11-23 17:15:20,433 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate]
      User does not have permission to perform this operation on table 'datenbank_info'.

      I can't grant the user those permissions (it is not my DB) and
      all access i need is read-only.

      How can i avoid those 'alter table' calls?