Revoking Privileges From Roles

Use one of the REVOKE statements to revoke a privilege from a role.

=> REVOKE INSERT ON applog FROM logwriter;
REVOKE PRIVILEGE

Revoking a privilege immediately affects any user sessions that have the role active. When you revoke a privilege, it is immediately removed from users that rely on the role for the privilege.

See the SQL Reference Manual for the different REVOKE statements.