sec_rolePermissions
List database-level permissions granted to a Teradata role. Use to analyze what access rights a role has or what it is allowed to do.
Instructions
List the database-level permissions granted to a named Teradata role. Use when the user asks what access rights a ROLE has, what a role is allowed to do, or what permissions have been granted to a role. Do NOT confuse with user-level queries — use sec_userDbPermissions for a user's direct permissions or sec_userRoles for a user's role membership. Requires a role name.
Arguments: role_name - Role name to analyze. persist - If True, materializes result as a volatile table and returns table name
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| persist | No | If True, materializes result as a volatile table and returns table name | |
| role_name | Yes | Role name to analyze. |