• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

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

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
BCSITS
Asked:
BCSITS
  • 2
1 Solution
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
You can find the users by checking the view

SELECT * FROM sys.database_principals

You can also you
EXEC sp_helprotect
0
 
BCSITSAuthor Commented:
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
 
BCSITSAuthor Commented:
I have since contacted the vendor of the application and they have advised that this function has been locked and cannot be performed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now