[DEPRECATED–please use GPUdb.grant_permission() instead] Grants a table-level permission to a user or role.
Parameters
Name of the user or role to which the permission will be granted. Must be an existing user or role.
Permission to grant to the user or role. Allowed values are:
table_admin – Full read/write and administrative access to the table.
table_insert – Insert access to the table.
table_update – Update access to the table.
table_delete – Delete access to the table.
table_read – Read access to the table.
Name of the table to which the permission grants access, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table, view, or schema. If a schema, the permission also applies to tables and views in the schema.
Optional filter expression to apply to this grant. Only rows that match the filter will be affected. The default value is ‘’.
Optional parameters. Allowed keys are:
columns – Apply security to these columns, comma-separated. The default value is ‘’.
The default value is an empty dict ( ).
Returns
A dict with the following entries–
Value of input parameter name.
Value of input parameter permission.
Value of input parameter table_name.
Value of input parameter filter_expression.
Additional information.