Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: How to find out Usersinfo using JDBC Connection to SQL Server

    Hi..


    I want to find out the List of users created in SQL Server.

    Im using type 4 Driver to Connect SQL Server.


    Regards
    maruthi.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    List of active users, users for a database or logins for the sql server ?
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

  3. #3
    Join Date
    Sep 2003
    Posts
    522
    select * from master.dbo.syslogins
    select * from master.dbo.sysxlogins
    select * from your_database.dbo.sysusers

  4. #4
    Join Date
    Jan 2004
    Posts
    3

    Thanks

    Thanks


    the problem is solved.

Posting Permissions

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