Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:mssql:mssql_basic_queries

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
dba:mssql:mssql_basic_queries [2023/08/14 16:35] – [Last hour events] dodgerdba:mssql:mssql_basic_queries [2023/08/15 08:59] (current) – [Last hour events] dodger
Line 1: Line 1:
 ====== MSSQL: Basic queries ====== ====== MSSQL: Basic queries ======
 +====== Information ======
  
 ===== Users ===== ===== Users =====
-==== All user info ====+==== All users info ====
  
 <code sql> <code sql>
Line 31: Line 32:
 ; ;
 </code> </code>
 +
 +
 ===== Databases ===== ===== Databases =====
 ==== List databases ==== ==== List databases ====
Line 58: Line 61:
     sys.event_log     sys.event_log
 WHERE WHERE
-    start_time > DateAdd (HOUR, -1, CONVERT(datetime2, SYSDATETIME ())); +    start_time > DateAdd (HOUR, -1, CONVERT(datetime2, SYSDATETIME ())) 
 +ORDER BY start_time DESC;
 </code> </code>
  
Line 76: Line 79:
 </code> </code>
  
 +====== Administration ======
 +
 +===== Create user =====
 +<code sql>
 +CREATE USER [dodger] WITH PASSWORD='strong_password', DEFAULT_SCHEMA=[the_schema]
 +GO
 +</code>
 +===== add user to role =====
 +<code sql>
 +sys.sp_addrolemember @rolename = N'db_owner', @membername = N'dodger'
 +GO
 +</code>
  
dba/mssql/mssql_basic_queries.txt · Last modified: 2023/08/15 08:59 by dodger