Using QMF

Allowing users to update specific columns in your tables

You can give another user authority to update specific columns in your tables.

The following example shows you how to give LINDSAY the authority to update the LOCATION column in the CALENDAR table.

To give user authority for specific columns:

1. Run this query to allow another user to view the data in the query and to select rows to change:

   GRANT SELECT ON tablename TO userid
   

2. Run this query to allow another user to update a specific column in the table:

   GRANT UPDATE(columnname) ON tablename TO userid
   

   For more information on the GRANT SQL keyword, see the SQL reference manual for your database management system.