Finding all logins that can alter DDL

  • Hello experts,

    Is there a ready-made query out there that I could run on a server to list all the logins that have the ability to alter DDL in any of the databases?

    I know some of this can be retrieved by finding members of db_ddladmin, but there could also be individually granted permissions for db users that I want to find as well, preferably without having to run a general permissions script that I would have to filter (read/write permissions, etc.).

    Thanks for any help.

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply