What user should be used and are there any security concerns? What are the minimum privileges for the SQL Server user to load the SQL Server module?
It is recommended that a system DSN that uses Integrated Security be used, and the Halcyon PrimeAlert Agent service be run under a user that has administrative authority on the MS SQL Server. When integrated security is used, a dummy user name and password should be specified when loading the module. If the system DSN is not using Integrated Security or the PrimeAlert agent service is not running under a user who has administrative privileges, and you wish to be able to see the input buffer of each running process in the User Activity table, you will have to specify the SA user and password when loading the module. You cannot use a username which is merely aliased to the SA account in the master database. If you decide not to utilize the above options, and wish to use another internal MS SQL Server user with un-integrated security on the DSN, the following permissions must be granted to the internal database user that you do use: – In the master database execute privilege on sp_server_
Related Questions
- What user should be used and are there any security concerns? What are the minimum privileges for the SQL Server user to load the SQL Server module?
- What are the user groups for and how do I set them up in the security center if I want to restrict the privileges for some users?
- What are the minimum privileges required for an Oracle user to load the Oracle module?
