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”