Privilege | Results |
SELECT | Granted if the grantor can grant SELECT privilege on all tables and views in the view definition. |
UPDATE | Granted for all columns for which the grantor can grant UPDATE privilege. If the grantor was granted UPDATE...WITH GRANT OPTION on a subset of the columns of a table, UPDATE is granted only for those columns. |
INSERT | Granted if the grantor can grant INSERT privilege on all tables and views in the view definition. |
DELETE | Granted if the grantor can grant DELETE privilege on all tables and views in the view definition. |
REFERENCES | The REFERENCES privilege is not valid for views. |