We have an application called "Redmap Document Manager" that uses an external SQL database to store data. We use a GUI interface to administer this program and all the information is recorded in the database. What we would like to do is perform an audit of the internal database users (users of the application itself) to see what rights they currently have.
We have contacted the app vendor and they have been useless so i was hoping to find some assistance here.
Does anyone know how to query a database to find this information? This is not to find which SQL users have access to the database but the users that have access in the application. I assume a user list is within the database and this is what we would like to query.
We are using SQL 2008 R2 on Windows 2008
Redmap Application ver. 18.104.22.168
If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention.
Multiple USB devices need t…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility.
Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…