1.0 Fortanix Key Insight - On-Premises Permissions
This article outlines the minimum database permissions required for Fortanix Key Insight to scan an on-premises connection. These permissions ensure secure and accurate access to keys and resources within supported databases.
2.0 Database Permissions Overview
To successfully integrate and scan an on-premises database in Fortanix Key Insight, the database user must have the following permissions:
Read access to catalog table views in the target database.
Server-level permissions to:
View any definition
View server state
For more information on how to provide these permissions in Microsoft SQL Server, refer to Section 3.0: Database Permissions in Microsoft SQL Server.
3.0 Database Permissions in Microsoft SQL Server
If a new user has been added to the Microsoft SQL Server, ensure that the minimum required permissions are granted to support integration with Fortanix Key Insight for an on-premises connection.
Perform the following steps to provide the necessary permissions:
Open Microsoft SQL Server Management Studio (SSMS).
Navigate to Security → Logins.
Select the appropriate user.
Right click the user and select Properties.
In the Login Properties page, go to User Mapping and select the required databases with read permissions.
In the Securables section, enable the following permissions:
View any definition
View server state
Figure 1: Assign minimum user permissions
Click OK to save the changes.