Column-level Authorization
The following command grants a role the
SELECT
privilege on a column:
GRANT SELECT(column_name) ON TABLE table_name TO ROLE role_name;
The following command can be used to revoke the
SELECT
privilege on a column:
REVOKE SELECT(column_name) ON TABLE table_name FROM ROLE role_name;
Any new columns added to a table will be inaccessible by default, until explicitly granted access.
Actions allowed for users with SELECT privilege on a column:
Users whose roles have been  ...