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

    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
    In front of the computer
    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.

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

  3. #3
    Join Date
    Jul 2004

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