Revokes query access to a node from a role.
Note that by default a node provides open query access to all roles and only an explicit grant of query access to a node can be revoked.
Available in a network database and requires the star$grant role.
Parameters:
| Name | Optional | Type | Description |
| node$ | Mandatory | Text | Node to revoke query access from |
| role$ | Mandatory | Text | Role to be revoked |
Examples:
SELECT revoke_node('mynode','myrole'); -- revokes role 'myrole' query access from 'mynode'.
Tips:
- The star$nodes view lists existing nodes in the network
Comments
Article is closed for comments.