revoke_columns

Revokes query access to one or more columns in a table from a role.

Available in a network database and requires the star$grant role.

Parameters:

Name	Optional	Type	Description
table$	Mandatory	Text	Table that contains the columns
columns$	Mandatory	Text	List of columns to revoke access from
role$	Mandatory	Text	Role to be revoked

Examples:

SELECT revoke_columns('mytable','col1,col2','myrole'); -- revokes role 'myrole' query access from columns 'col1' and 'col2' in table 'mytable'.

Tips:

• The star$columns view lists columns in existing tables