Microsoft® SQL Server Plugin
What Does the Microsoft® SQL Server Plugin Do?
The Microsoft SQL Server plugin allows you to manage users and database roles via tenfold, for instance:
When an action (such as creating a new user account or assigning a permission) must be performed in an application and this action cannot be automated via another plugin. This might occur if the application does not provide an API or developing a plugin is too time-consuming or complex.
When a request that cannot generally be automated is generated in tenfold. This could be a request for a piece of hardware or other type of asset.
Required License
System Requirements
- tenfold 2019 R4 Update 2
- Microsoft SQL Server 2017® bzw. Microsoft SQL Server 2019®
Automation: tenfold transfers any changes made to database roles automatically. This saves times as manual tasks are eliminated.
Reporting: Keep a constant overview of who has what database roles or which database roles are assigned to which users.
Profiles/Roles: Database roles can be grouped together with resources and permissions from other systems and then linked to organizational units. Database roles are assigned to users automatically and can be removed when necessary.
Approval Workflows: Both single-level and multi-level workflows are possible. Escalations and substitutes can be configured easily.
Self-Service: Users can request database roles independently through the intuitive HTML5 interface. Settings and privileges can be used to control specifics. Learn more about tenfold´s self-service.
Recertification: Data owners can regularly review whether database roles are up to date and mark obsolete entries for removal. tenfold then automatically removes the associated role assignments. Learn more about tenfold and recertification.
Auditing: Any changes made to database roles are documented automatically. Historical data can be accessed at any time and you can keep track of who had access to sensitive data.
Integration of Data Owners: Define data owners from different departments who are in charge of approving applications and keep track of database roles on a regular basis.
