Finding all logins that can alter DDL

• webrunner

  SSC-Dedicated

  Points: 31713

  More actions

  October 22, 2021 at 3:56 pm

  #3943335

  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

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  October 23, 2021 at 4:10 pm

  #3943617

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

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