REVOKE PRIVILEGES

revoke_privilege_statement
    :    REVOKE PRIVILEGES FROM grantee_list 

privileges
    :    ALL [PRIVILEGES] ON object_name

object_name
    :    db_name.*

grantee_list
    :    character_string_literal (COMMA! character_string_literal)*

object_name

the name of object for which privileges are revoked.

db_name

the name of database.

grantee_list

the list of users for which some privileges are revoked for particular object.

This command force Valentina Server to revoke the privileges for particular object from users mentioned in grantee list. This command is available for ADMINISTRATOR of vserver only.

• ERR_CONNECTION_OPERATION_NOT_PERMITTED - Valentina is running in local mode or query-issuer is not administrator of Valentina Server.

• ERR_CONNECTION_USER_NOT_EXISTS - some user mentioned in grantee_list is not exist.

• ERR_DB_NOT_FOUND - database with the specified name is not registered to Valentina Server.

• ERR_DB_IDENTIFIER_NOT_FOUND - Database does not contain the object with specified name.

Example:

REVOKE ALL ON db1.* FROM User1;