Results 1 to 2 of 2

Thread: Query to get Login Permission

  1. 11-20-2006, 12:10 PM #1
    bobkand
    bobkand is offline Registered User
    Join Date
    Sep 2005
    Posts
    43

    Question Query to get Login Permission

    Some one does have any query that can pull the

    Login Name,
    Databases it has access,
    and Permissions on that database(Like read, insert...etc).

    Any clues for writing a query on the same is appreciated.
    Reply With Quote Reply With Quote
  2. 11-20-2006, 01:25 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You will have to query sysprotects table in each database to get that information. syslogins table in master can only tell you server wide access.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules