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:

 

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk