-- Operator metadata belongs to the asset, not the installation or its inventory. ALTER TABLE assets ADD COLUMN purpose text CHECK (char_length(purpose) BETWEEN 1 AND 500); GRANT UPDATE(purpose) ON assets TO rmm_app;