Table and Views Permissions Overview

There are several distinct permissions that may be granted to user IDs concerning tables and views:

Permission

Description

ALTER

Permission to alter the structure of a table

DELETE

Permission to delete rows from a table or view

INSERT

Permission to insert rows into a table or view

REFERENCES

Permission to create indexes on a table, and to create foreign keys that reference a table

SELECT

Permission to look at information in a table or view

UPDATE

Permission to update rows in a table or view. This may be granted on a set of columns in a table only

ALL

All the above permissions

In a multiplex, only write servers can modify table permissions on tables owned by the write server.