Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    9

    Question Unanswered: How to find particular login has access to which databases?

    Is there a way to get the list of database to which a particular login name has access to and also how find what access that particular login has in each database?

    Appreciate your comments and suggestions

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    Give sp_helplogins a try

  3. #3
    Join Date
    Feb 2002
    Posts
    9
    Thanks! for the reply.. I had figured that out.. sp_helplogin is helpful.

Posting Permissions

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