Home Forums SQL Server 2005 SQL Server 2005 Security Identify/May Application users in sql 2005 database RE: Identify/May Application users in sql 2005 database

  • April 29, 2015 at 12:30 pm

    #1794438

    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!