Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: SQL Server Logins

    Hello All,

    I have named logins and generic logins. For example, jsomebody and test. I need to write a query to exclude named logins. Not sure how to do it. Any ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Is there some common criteria that will let you pick between the generic and the user-specific logins? All of them are "named" from my perspective, but without knowing exactly what or how you've named them I can't guess if there is a way to distinguish them.

    There could also be some criteria besides the names that would let you separate the logins too.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jul 2004
    Posts
    268

    SQL Server Logins

    the login that I create for the application to connect to the database might be called appuser, and the user that I create for user to only select data might be called jsmith.

  4. #4
    Join Date
    Oct 2011
    Posts
    29
    do your appuser is having any uniqueness in a string? if yes then you can filter it out and exclude the others by query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •