This article describes how to set permissions to run theApexSQL Audit GUI.
By default after the installation, Administrators and Users groups are granted permissions to execute the ApexSql.Audit.Gui.exe file – i.e. to run the ApexSQL Audit GUI. All examples below are based on a machine that belongs to Workgroup – the same logic applies to a domain.
How to deny access to a specific user
All users need to have access to the ApexSQL Audit GUI, except one – JohnSmith. A rule must be added to the Windows file properties that denies file access to JohnSmith.
Navigate to the folder where ApexSQL Audit is installed. By default c:\ProgramData\ApexSQL\ApexSQLAudit\Bin\
- Right click the ApexSql.Audit.Gui.exe and choose Properties
- Open the Security tab
- Click Edit
- Click Add…
Enter a username or group name
- Click OK
- The new entry will be added
Check all Deny options in the Permissions section
- Click OK
When this user tries to run the ApexSQL Audit GUI, the following error message is thrown
How to deny access to a group of users
To deny access to a whole group of users follow the steps described above. A rule must be added in the Windows properties that denies access to all users from the Guests group.