Grants a role query access to a node.
Note that by default a new node provides open query access to all roles. However, once a node has been granted one or roles the node becomes limited to query access only to those roles.
Available in a network database and requires the star$grant role.
Parameters:
| Name | Optional | Type | Description |
| node$ | Mandatory | Text | Node to grant query access to |
| role$ | Mandatory | Text | Role to be granted |
Examples:
SELECT grant_node('mynode','myrole'); -- grants role 'myrole' query access to node 'mynode'.
Tips:
- The star$nodes view lists existing nodes in the network
- The star$roles view lists existing roles
Comments
Article is closed for comments.