SELECT * FROM sysusers ;
SELECT * FROM sysusers WHERE hasdbaccess = 1;
SELECT * FROM sysusers ;
SELECT database_id, name, collation_name, user_access, is_read_only FROM sys.databases;
While connected to a database and using master
SELECT * FROM sys.event_log;
SELECT * FROM sys.event_log WHERE start_time > DateAdd (HOUR, -1, CONVERT(datetime2, SYSDATETIME ())) ORDER BY start_time DESC;
SELECT * FROM sys.event_log WHERE event_subtype_desc <> 'connection_successful' ORDER BY start_time DESC OFFSET 11 ROWS FETCH NEXT 10 ROWS ONLY;
CREATE USER [dodger] WITH PASSWORD='strong_password', DEFAULT_SCHEMA=[the_schema] GO
sys.sp_addrolemember @rolename = N'db_owner', @membername = N'dodger' GO