Switch to: V9V8V7V6V5
Table of Contents

SHOW GRANTS

[NEW in 4.0]

The SHOW GRANTS statement is used to list users' privileges of a Valentina Server.

Syntax

SHOW GRANTS [{FROM|OF} grantor]

grantor
    :    CURENT_USER
    |    character_string_literal

Result Columns

  • userName

The user login name.

  • privilegeName

Specifies list of privilege types.

  • privilegeOption

Specifies allow/deny state for the list of privileges.

  • privilegeObjectType

Specifies object type for the list of privileges.

  • privilegeObjectName

Specifies object name for the list of privileges. “*” means “any object of this type”