I want to tighten my security in SQL for the users of Exact Globe Next, but how should I set this up?
Security in SQL can be very easy and straight forward, but it can be made very complex as well. The goal of this document is to be a guideline to setup security in SQL for Exact Globe Next in an manageable way and to be used to setup security that users can do in Exact Globe Next what they need to do. In this document it is assumed that an active directory (domain) is installed, if this is not the case this needs to be done first otherwise working with Exact Globe Next in a multi-user environment is not supported.
When setting up security it is always advisable to do this via groups. By putting people in groups, security can be easily distributed by putting people into groups and by moving them out of groups. The following things have to be taken into account:
Setup access for Exact Globe Next users in SQL:Please note that after this step users cannot do any of the four specific tasks mentioned above.
After these steps the users have the ability to connect to Exact Globe Next and open a database, but they cannot run any queries via other programs (Excel, Query analyzer, Enterprise Manager, etc) than Exact Globe Next.
In order to be able to do the special actions, you need special access rights in SQL. Below is a table with the function in Exact the users wants/needs to do and the role you need in SQL.
Setup special access for Exact Globe Next users in SQL: