Identify/May Application users in sql 2005 database

Question

Post reply

Identify/May Application users in sql 2005 database

mtz676

SSCrazy Eights

Points: 9212
More actions
April 29, 2015 at 11:13 am

#303385

Is it possible to identify/map app users inside sql 2005 database?If so how?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

certainly, with more information.

map to what? active directory? a separate table? SQL users to SQL logins?

give us a bit more detail what you are after.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

mtz676 SSCrazy Eights Points: 9212 More actions · Answer 2

I see application users in the application but I do not see them in the database as users ?

These app users can connect to the database using their logins.But I cant find these app users in the database?

How do I identify these app users in the database?What are they part in the database that they are able to connect to the database through their logins from the application?

Lowell SSC Guru Points: 323518 More actions · Answer 3

metroman17 (4/29/2015)
I see application users in the application but I do not see them in the database as users ?
These app users can connect to the database using their logins.But I cant find these app users in the database?
How do I identify these app users in the database?What are they part in the database that they are able to connect to the database through their logins from the application?

in that case, probably not;

it's very common that an application uses a single SQL login to connect to the database and do all all the work under that login. so all the application users may login to the app, but it's up to the application to track who updated what. i'd almost expect the SQL server for the app to have one SQL Login , and no windows Logins at all.

only if you were lucky enough to have an app that is using a trusted connection , that it also passes through to the SQL connection would you get what you are after.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!