For an introduction to Action Access Requests, see Action Access Requests Overview.
Configuring time-based access instead? See JIT Access Requests Configuration.
Enabling Action Access Requests
Via Web App
Action Access Requests are configured as an Access Request rule of type by Command.Create a new rule
Click Create new Access Request rule. If you don’t have any rules yet, you’re taken straight to the rule form.
Choose the access request type
Select the Access request type:
- Just-in-Time — temporary access that expires automatically after a defined time range.
- by Command — execution-based access with a per-command approval workflow.
Select resource roles
Under Resource configuration, choose the resource roles this rule applies to. Optionally, use Attribute configuration to scope the rule further.
Set user groups
- Required user groups — the groups that must request access under this rule.
- Approval user groups — the groups that can approve access for this rule.
Tune approval controls (optional)
- Require all groups approval — require approval from at least one member of each approval group.
- Approval amount — the minimum number of approvals required per session.
- Force approval groups — groups allowed to bypass the other approval rules.
Via CLI
Enable Action Access Requests when creating a resource role:--reviewers flag specifies which groups can approve commands.
Add reviewers to an existing resource role:
Approval Group Configuration
Single Approver Group
When one group is configured, any member of that group can approve:dba-team can approve or reject.
Multiple Approver Groups
When multiple groups are configured, all groups must approve:- Request requires 1 approval from
dba-teamAND 1 approval fromsecurity-team - Either group can reject the request
- Request stays pending until all groups approve
Exempt Groups
Admin users automatically approve their own requests. To test the full workflow, use a non-admin account.Timeout Configuration
Set how long to wait for approval before the request expires.Gateway Environment Variable
| Value | Duration | Use Case |
|---|---|---|
300 | 5 minutes | Quick ad-hoc queries |
1800 | 30 minutes | Standard operations |
3600 | 1 hour | Complex procedures |
7200 | 2 hours | Long approval chains |
What Happens on Timeout
When a request times out:- Status changes to EXPIRED
- User sees a timeout error
- Command is not executed
- User must resubmit the command
Notification Configuration
Slack Integration
To receive and approve requests in Slack:- Configure the Slack integration
- Enable the
slackplugin on your resource role:
- Approvers subscribe with
/hoop subscribein Slack - Access requests appear as interactive messages with Approve/Reject buttons
Microsoft Teams Integration
To receive notifications in Teams:- Configure the Teams integration
- Enable the
webhooksplugin - Notifications are sent to the configured Teams channel
Custom Webhooks
For custom integrations:- Configure webhook endpoint in Integrations > Webhooks
- Receive POST requests for new access requests
- Call the API to approve/reject:
Common Configurations
Production Database - DBA Approval
Only DBAs can approve production database commands:Sensitive Operations - Dual Approval
Require both DBA and Security approval:Read-Only with Approval
Approval for read access to sensitive data:Monitoring Access Requests
Viewing Pending Requests
Web App:- Go to Access Requests in the sidebar
- Filter by Status: Pending
- Click any request to see details
Access Request Analytics
Track approval patterns:| Metric | How to Find |
|---|---|
| Average approval time | Access Requests > Export > Calculate |
| Approval rate | Count approved vs rejected |
| Top requesters | Group by user |
| Common commands | Group by command pattern |
Audit Trail
Every access request is logged with:- Who requested
- What command
- Who approved/rejected
- When each action occurred
- Full command output (if approved)
Troubleshooting
Notifications Not Arriving
Check Slack:- Slack app is installed correctly
- Resource role has
slackplugin enabled - Approver has run
/hoop subscribe - Notification channel is configured
- Webhook URL is valid
webhooksplugin is enabled- Teams channel allows incoming webhooks
Requests Auto-Approved
Admin users auto-approve their own requests. This is expected behavior. To test the full workflow:- Use a non-admin test account
- Or create a resource role where the admin is NOT in the approvers group
Request Times Out Too Quickly
Increase the timeout:Can’t Find Pending Request
Check:- Request hasn’t already expired
- You’re looking at the correct resource role
- Filter is set to show Pending status
Environment Variables
| Variable | Description | Default |
|---|---|---|
REVIEW_TIMEOUT_SEC | Seconds before request expires | 3600 |
Related
Action Access Requests
Feature overview and use cases
JIT Access Requests
Configure time-based access
Slack Integration
Set up Slack notifications
Teams Integration
Set up Teams notifications