revoke_table

Revokes query access to 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 to revoke query access from
role$	Mandatory	Text	Role to be revoked

Examples:

SELECT revoke_table('mytable','myrole'); -- revokes role 'myrole' query access from 'mytable'.

Tips:

• The star$tables view lists existing tables in the network