List all permissions assigned to user defined SERVER roles

• lan2022nguyen

  SSC-Addicted

  Points: 459

  More actions

  September 12, 2022 at 12:29 pm

  #4086591

  Kindly help me with a T-SQL for finding all permissions assigned to user defined SERVER roles.

  Thanks

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  September 12, 2022 at 2:22 pm

  #4086653

  check this link

  https://dba.stackexchange.com/questions/36618/list-all-permissions-for-a-given-role

  Regards
  Durai Nagarajan