You can execute the REVOKE
statement to revoke permissions from an account.
REVOKE
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
ON [object_type] priv_level
FROM user
Parameters
priv_type
: the type of the permission to revoke. For more information, see Permission model.column_list
: optional. If thepriv_type
parameter is set toSELECT
, you can enter the names of columns to revoke theSELECT
permission on these columns.priv_level
: the level of the permission to revoke.*.*
: the cluster level.db_name.*
: the database level.db_name.table_name
ortable_name
: the table level.
Precautions
To revoke permissions from accounts by executing the REVOKE
statement, you must have the GRANT OPTION
permission.
Example
Revoke the database-level all
permission of account3.
REVOKE all ON adb_demo.* FROM 'account3';