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.