Teradata - 如何检查用户是否有"WITH GRANT"选项?



如何检查用户是否在teradata中选择"赠款"选项?我知道如何使用dbc.rolemembers和dbc.allrolerights获取权限列表,只是看不到检查是否允许使用" with Grant"选项。

谢谢

GrantAuthority仅存在于AllRightsVUserGrantedRightsVUserRightsV中,出于简单的原因:

5613 GRANT OPTION cannot be granted to a role.
Explanation: WITH GRANT OPTION can only be granted to users or databases.
Generated By: resname2 module.
For Whom: End User.
Remedy: Remove WITH GRANT OPTION and re-submit request.

最新更新