Why can't I update my SQL Table, Privilege Grants look OK

There are two levels of control over updates to SQL Tables in Reality as well as the SQL Privileges, which control access by userid, each table can be marked as Updateable, or Read-Only.

If a Table is marked Read-Only, this overrides update privileges assigned to any user (including the table owner).

To check whether a table is Updateable and to change this status use SQLM, select Amend Table Definitions, specify the Table name and then choose Toggle Update Permission.

Back to articles