Connection Reservation and Approval

within the sql proxy module, users are required to create a reservation when attempting to connect to a database this reservation specifies the time frame for access and must be approved by a manager to create a connection reservation the policy group must contain approval definitions first, create an approval workflow that indicates what to do if some kind of reservation is created navigate to policy > approval workflow then click +add button users must log in to the pam interface specific user groups, such as mssql user groups, may exist, and members of these groups are required to obtain approval from a manager before accessing databases users create a reservation by selecting the target database and specifying a reason for the connection for example, users may need to perform tasks such as creating tables or retrieving data this reason is communicated to the manager for approval navigate to devices > reservation and create a reservation the manager reviews the reservation request, which includes details such as the user’s name, the target database, and the reason for the request the manager may approve, reject, or ignore the request without approval, the user will not be able to connect to the database user manager needs to navigate to the dashboard page and approve the request in my approvals once the reservation is approved, the user is allowed to connect to the database within the specified time frame during this session, additional policies may govern the queries that can be executed