Home Forums SQL Server 7,2000 T-SQL Query to get all logins and access info RE: Query to get all logins and access info

  • Hi JMeyers32,

    sp_helpprotect should do what you need

    This is taken from BOL:

    A. List the permissions for a table

    This example lists the permissions for the titles table.

    EXEC sp_helprotect 'titles'

    B. List the permissions for a user

    This example lists all permissions that user Judy has in the current database.

    EXEC sp_helprotect NULL, 'Judy'

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]