Skip to main content
revoke_permission_table(name=None, permission=None, table_name=None, options=)[source]

[DEPRECATED–please use GPUdb.revoke_permission() instead] Revokes a table-level permission from a user or role.

Parameters

name (str) –

Name of the user or role from which the permission will be revoked. Must be an existing user or role.

permission (str) –

Permission to revoke from 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.

table_name (str) –

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.

options (dict of str to str) –

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–

name (str) –

Value of input parameter name.

permission (str) –

Value of input parameter permission.

table_name (str) –

Value of input parameter table_name.

info (dict of str to str) –

Additional information.