Proxy login and execute
Syntax for authorizing proxy logins and executes.
Allow a role to execute individual commands or all commands as another role. Typically used when users are interacting with the database through an application that authenticates the users before sending the request to the DataStax Enterprise database.
Synopsis
- To allow a role to proxy execute and login with another
role
GRANT PROXY.EXECUTE, PROXY.LOGIN ON ROLE role_name TO application_role;
Revoke permissions
syntax:
REVOKE permission_name
ON ROLE role_name
FROM application_role;
Proxy permissions
Privilege | Resource | Permissions |
---|---|---|
PROXY.EXECUTE | ALL ROLES | After authenticating issue individual requests as any specified role. |
PROXY.LOGIN | ROLE role_name | After authenticating issue all requests as any specified role. |
PROXY.EXECUTE | ROLE role_name | After authenticating issue individual requests as a different user. |
PROXY.LOGIN | ROLE role_name | After authenticating issue all requests as a different user. |