grant_table

Grants a role query access to a table.

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

Parameters:

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

Examples:

SELECT grant_table('mytable','myrole'); -- grants role 'myrole' query access to table 'mytable'.

Tips:

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk