Microsoft SQL Server
Britive integrates with Microsoft SQL Server through the Britive Access Broker. The broker uses sqlcmd to create a temporary SQL Server login and database user at checkout, assigns the db_owner role, and drops the login along with any active sessions at checkin.
Scripts are available in both Bash (Linux broker) and PowerShell variants.
Access Patterns
- Temporary DBA access — creates a temporary SQL Server login and database user with
db_ownerin the target database. Active sessions are terminated and the login dropped at checkin.
The broker must have network access to SQL Server on port 1433. sqlcmd must be installed on the broker host.
In This Section
- Getting Started
Set up the Britive Access Broker for JIT access to Microsoft SQL Server — install sqlcmd, create a service account with the required permissions, and register the SQL Server instance as a resource.
- Temporary DBA Access
Create a temporary SQL Server login with db_owner privileges at checkout — kill active sessions and drop the login at checkin. Available in Bash and PowerShell.