ImLogAccessRoles - System Parameter
The system parameter ImLogAccessRoles controls what SQL rights gets assigned by the Logging Service on new Log Databases using values from the list of users in the ImLogServiceUsers System Parameter.
If you have different accounts for the different Core Services you must make sure that all accounts are listed in the ImLogServiceUsers System Parameter
System Parameter Name | Data Type | Values/Example | Comment |
---|---|---|---|
ImLogAccessRoles | string | db_datareader ; db_datawriter;db_ddladmin |
Default = db_datareader ; db_datawriter |
semicolon separated list of access rights
This feature comes with Nodinite version 3
Frequently asked questions
Additional solutions to common problems and the FAQ for the Nodinite System Parameters 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
ImLogServiceUsers
Administration