Example 1: Grant all privileges on the table WESTERN_CR to PUBLIC.
GRANT ALL PRIVILEGES ON WESTERN_CR TO PUBLIC
Example 2: Grant the appropriate privileges on the CALENDAR table so that PHIL and CLAIRE can read it and insert new entries into it. Do not allow them to change or remove any existing entries.
GRANT SELECT, INSERT ON CALENDAR TO PHIL, CLAIRE
Example 3: Grant column privileges on TABLE1 and VIEW1 to FRED. Note that both columns specified in this GRANT statement must be found in both TABLE1 and VIEW1.
GRANT UPDATE(column_1, column_2) ON TABLE1, VIEW1 TO FRED WITH GRANT OPTION
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.