LogAccessRoles - System Parameter
The Nodinite System Parameter LogAccessRoles defines the SQL Server database roles assigned by the Logging Service when creating new Log Databases. These roles are granted to the service users specified in the 'LogServiceUsers' System Parameter.
Important
You must include all unique service accounts for Nodinite Core Services in the 'LogServiceUsers' System Parameter.
| System Parameter Name | Data Type | Values/Example | Comment |
|---|---|---|---|
| LogAccessRoles | String | db_datareader;db_datawriter;db_ddladmin |
Default: db_datareader;db_datawriter;db_ddladmin |
Semicolon-separated list of SQL database roles.
Overview & Benefits
Nodinite offers multiple System Parameters to fine-tune instance behavior, and managing access rights supports the principle of least privilege. Ensuring proper role assignments enhances security and may be required by company policies.
Why This Matters for Your Business
✅ Enhanced Security & Compliance – Maintain strict control over database access, aligning with security policies and regulatory requirements.
✅ Operational Efficiency – Automate role assignments for new : Nodinite: Log Databases, reducing manual configuration and human error.
✅ Scalability & Flexibility – Easily manage access as your environment grows, ensuring new databases are securely provisioned with the right permissions.
✅ Reduced Risk & Least Privilege Enforcement – Limit access to only necessary SQL database roles, minimizing exposure to potential security threats.
✅ Seamless Integration – Works in conjunction with the LogServiceUsers parameter, ensuring all necessary service accounts are properly configured.
History
- The System Parameter was renamed from '
ImLogAccessRoles' in Nodinite version 7 New 7.x. - This feature was introduced in Nodinite version 3 New 3.x.
Frequently asked questions
Additional solutions to common problems and the Nodinite System Parameters FAQ exist in the Troubleshooting user guide.
How do I change the value?
Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.
Can I manually assign access rights?
If you intend to manually assign access rights (which you must if you create the Log Databases manually), follow the checklist in the 'What permissions does Nodinite need?' summarizing table for Nodinite.
Next Step
LogServiceUsers
Administration