• Home
• us.fatehi
• schemacrawler-sqlserver
• 16.22.3
• source code
• DATABASE_USERS.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sqlserver.information_schema.DATABASE_USERS.sql Maven / Gradle / Ivy

SELECT
  NAME AS USERNAME,
  CREATE_DATE,
  MODIFY_DATE,
  TYPE_DESC AS TYPE,
  AUTHENTICATION_TYPE_DESC AS AUTHENTICATION_TYPE
FROM
  SYS.DATABASE_PRINCIPALS
WHERE
  TYPE_DESC NOT IN ('A', 'G', 'R', 'X')
  AND SID IS NOT NULL
  AND NAME != 'GUEST'
ORDER BY
  NAME;