Re: plz-help enumeration database objects that users roles have ?

From: simo sentissi (simo_sentissi_at_skc.edu)
Date: 01/28/04

  • Next message: Paul L: "Delegation Failure" 
    Date: Wed, 28 Jan 2004 08:30:45 -0700

    well I just want a listing of user roles and their security rights on DB
    objects.
    I am looking at the stored procs now but if there is soemthing already done
    outhere then it will save me some work.

    "Anith Sen" <anith@bizdatasolutions.com> wrote in message
    news:uYCCFJb5DHA.2404@TK2MSFTNGP11.phx.gbl...
    > Not sure what information you are exactly looking for, but you can get
    most
    > information from sp_helprotect, sp_helpuser & sp_helprole system
    procedures.
    > Please refer to SQL Server Books Online for more information on these
    > procedures.
    >
    > --
    > Anith
    >
    >

  • Next message: Paul L: "Delegation Failure"