Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to query a database to find user access rights in Redmap

Posted on 2014-02-24
3
Medium Priority
?
381 Views
Last Modified: 2014-02-25
Hi Guys,

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. 4.4.0.25

Any help is appreciated

Kind Regards,
0
Comment
Question by:BCSITS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
DBAduck - Ben Miller earned 1500 total points
ID: 39885391
You can find the users by checking the view

SELECT * FROM sys.database_principals

You can also you
EXEC sp_helprotect
0
 

Author Comment

by:BCSITS
ID: 39887423
Hi dbaduck and thanks for your reply.

The query you posted is for SQL logins attached to the database and i was hoping for a way to extract a list of users that can access the DB through the application itself.

I have since contacted the vendor of the application and they have advised that this function has been locked and cannot be performed.

Thanks for your assistance
0
 

Author Closing Comment

by:BCSITS
ID: 39887425
I have since contacted the vendor of the application and they have advised that this function has been locked and cannot be performed.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A procedure for exporting installed hotfix details of remote computers using powershell
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
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 Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question