• MS SQL Rights Report

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » MS SQL Rights Report

    • This topic has 1 reply, 2 voices, and was last updated 15 years ago.
    Author
    Topic
    WSNathan H
    AskWoody Lounger
    April 16, 2010 at 11:06 am #468239

    Just wondering how one would go about generating a report on the active directory user/group rights to all the databases, queries, reports, etc in a particular database on a 2000 SQL server?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WBell
      AskWoody_MVP
      April 16, 2010 at 11:42 am #1218909

      If you can connect to it using SQL Server 2005 or 2008 Management Studio, then you have the option of doing things with SQL Server Reporting Services. Otherwise it is a pretty complex task, and you have to work with the system tables in SQL Server. Unfortunately I don’t have access to a SQL Server 2000 system any more.

      Reply | Quote
    Viewing 0 reply threads
    Reply To: MS SQL Rights Report

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.