revoke_schema

Revokes query access to a schema from a role.

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

Parameters:

Name Optional Type Description
schema$ Mandatory Text Schema to revoke query access from
role$ Mandatory Text Role to be revoked

Examples:

SELECT revoke_schema('myschema','myrole'); -- revokes role 'myrole' query access from 'myschema'.

Tips:

  • The star$schemas view lists existing schemas in the network
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk