SHOW GRANTS IN DCM PROJECT

SHOW GRANTS IN DCM PROJECT lists all grants deployed and managed by the specified DCM project.

SHOW FUTURE GRANTS IN DCM PROJECT lists all grants that will be deployed and managed by the specified DCM project when the next deployment is executed.

该命令返回按创建日期排序的授权元数据和属性。

See also:

CREATE DCM PROJECT , ALTER DCM PROJECT, DESCRIBE DCM PROJECT , DROP DCM PROJECT, EXECUTE DCM PROJECT, SHOW DCM PROJECTS

语法

SHOW GRANTS IN DCM PROJECT <name> [ LIMIT <rows> ]

SHOW FUTURE GRANTS IN DCM PROJECT <name> [ LIMIT <rows> ]

必填参数

IN DCM PROJECT name

指定包含要列出的部署的 DCM 项目的标识符。

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

可选参数

LIMIT rows

Optionally limits the maximum number of rows returned. The actual number of rows returned might be less than the specified limit. For example, the number of existing objects is less than the specified limit.

Default: No value (no limit is applied to the output).

输出

SHOW GRANTS IN DCM PROJECT 返回以下输出，其中每个权限授予占一行：

  • CREATED_ON
  • PRIVILEGE
  • GRANTED_ON - object type, such as DATABASE, TABLE, ROLE
  • NAME - object name
  • GRANTED_TO - such as ROLE, DATABASE ROLE, SHARE
  • GRANTEE_NAME
  • GRANT_OPTION
  • GRANTED_BY
  • GRANTED_BY_ROLE_TYPE