You can assign a set of permissions on individual tables and views. Users can be granted combinations of these permissions to define their access to a table or view.
The ALTER (permission to alter the structure of a table) and REFERENCES (permission to create indexes and to create foreign keys) permissions grant the authority to modify the database schema, and so will not be assigned to most users. These permissions do not apply to views.
The DELETE, INSERT, and UPDATE permissions grant the authority to modify the data in a table or view. Of these, the UPDATE permission may be restricted to a set of columns in the table or view.
The SELECT permission grants authority to look at data in a table or view, but does not give permission to alter it.
ALL permission grants all the above permissions.