grant_schema

Grants a role query access to a schema.

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

Parameters:

Name	Optional	Type	Description
schema$	Mandatory	Text	The schema to grant query access to
role$	Mandatory	Text	Role to be granted

Examples:

SELECT grant_schema('myschema','myrole'); -- grants role 'myrole' query access to schema 'myschema'.

Tips:

• The star$schemas view lists existing schemas
• The star$roles view lists existing roles