Switch to: V9V8V7V6V5

REVOKE PRIVILEGES

Syntax

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)*

Arguments

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.

Description

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.

Errors

  • 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.

Examples

Example:

REVOKE ALL ON db1.* FROM User1;