dba:mssql:mssql_basic_queries

This is an old revision of the document!

Table of Contents

MSSQL: Basic queries
- Users

MSSQL: Basic queries

Users

All user info

SELECT
    *
FROM
    sysusers
;

Users with access

SELECT
    *
FROM
    sysusers
WHERE
    hasdbaccess = 1;

Non mssql internal users

SELECT
    *
FROM
    sysusers
;

dba/mssql/mssql_basic_queries.1692000269.txt.gz · Last modified: 2023/08/14 08:04 by dodger