Andrii Rosa
Andrii Rosa
# VIEW: APPLICABLE_ROLES `.information_schema.applicable_roles` Recursively Identifies the applicable roles for the current user in `` **Output Columns**: - `grantee` - `grantee_type` - - `role_name` - `is_grantable`
# VIEW: ENABLED_ROLES `.information_schema.enabled_roles` Recursively identify the enabled roles for the current SQL-session for `` **Output Columns**: - `role_name`
# SHOW CURRENT ROLES [follow-up] Shows all available roles in `` **Syntax**: ``` SHOW CURRENT ROLES (FROM )? ``` - If `` is not specified, session catalog is used -...
# PERMISSIONS As Presto is only data providers aggregator, no special permissions for invoking any of the above commands must be checked explicitly by Presto. All the commands must be...
> No “WITH GRANTOR” – seems like that’s a way that could be used to subvert security (e.g. you should have to log in as a particular user to issue...