Revoking Permission from a User or a Role

After a permission has been granted on a table, it can be subsequently revoked by using the tibdg user revoke or tibdg role revoke command.

Prerequisites

Procedure

  1. On a specific table, to revoke permissions from a user, use the tibdg user revoke command as shown in the following example:
    tibdg user revoke user1 table1 READ
    The other possible permissions are WRITE and ALL (read and write).
  2. On a specific table, to revoke permissions from a role, use the tibdg role revoke command as shown in the following example:
    tibdg role revoke role1 table1 READ
    The other possible permissions are WRITE and ALL (read and write).