Jun 23, 2020 10:30 AM
Here is some more information about the use of the SQL Server CLR feature by FlexNet Manager Suite On-premises.
FlexNet Manager Suite uses a signed CLR assembly with the SAFE permission set. As described at CLR Integration Code Access Security, assemblies with a SAFE permission set are restricted so that:
"Only internal computation and local data access are allowed. SAFE is the most restrictive permission set. Code executed by an assembly with SAFE permissions cannot access external system resources such as files, the network, environment variables, or the registry."
On Microsoft SQL Server 2017 and later, configuration to allow this assembly to be created and executed is typically done with a special SQL Server login created from the appropriate certificate provided by Flexera, and having UNSAFE ASSEMBLY rights granted to the login. Alternative supported (but not recommended) configurations are to set the TRUSTWORTHY database property to “ON” for the compliance database, or to disable CLR strict security.
The SQL Server CLR feature is used by FlexNet Manager Suite to efficiently perform various functions in the database related to data filtering for different users based on the access rights they have been granted through their role memberships.
Jun 25, 2020 09:04 PM