SingleStore Audit Logging: show user and admin activity
In this demo we look at #AuditLogging in #SingleStore. We start by turning on the basic logging to show successful and failed logins, then upgrade logging to also show Admin commands such as changing schema. Get started with SingleStore today at https://www.singlestore.com/
0:00 - Introduction
0:18 - What is the audit log?
0:30 - 1. User login auditing
0:44 - Audit logging is disabled by default
0:59 - Enable audit log
1:57 - Restart nodes to take effect
2:43 - Login to database
3:02 - Create second user
3:23 - Navigate to and view the login logs
4:00 - Both logins succeeded
4:32 - Login unsuccessfully
4:55 - Audit log shows login failure
5:12 - Log shows when log levels change
5:58 - 2. Show admin DDL commands in logs
6:53 - Restart to take effect
7:33 - Login as root and run DDL commands
8:06 - Show admin commands in audit log
8:51 - Review audit features
#MemSQL is now #SingleStore